This should be simple but...
I have a spreadsheet with thousands of lines of data
I need to remove some lines of data
The rule is...
If any cell in column A has a background colour that's not the default
(blank) then delete the whole row.
I know this should be a simple loop but recording a macro doesn't seem to
give me any clues. Any help would be appreciated.
Jeff
|