Hi Macropod,
I'm sorry for late reply. Please see attached for dummy table (well actually it's not a table but text boxes). So I'm having a hard time to create VBA where I can remove anything that has "No Color" (please see in yellow shades) and if it has more data on it's next rows, they need to be deleted as well.
|