ironsides
Well-known Member
- Joined
- Aug 12, 2002
- Messages
- 575
Starts Cel A11
Entire Col A has either color no data or data no color or both
Macro needed that will delete all lines below the first cell in col A that it detects has no color or data.
and keeps the initial blank line.
or
Keep the lines and delete all data and color after it finds no entry in Col A (This is my preference)
Entire Col A has either color no data or data no color or both
Macro needed that will delete all lines below the first cell in col A that it detects has no color or data.
and keeps the initial blank line.
or
Keep the lines and delete all data and color after it finds no entry in Col A (This is my preference)