View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_39_] Jeff[_39_] is offline
external usenet poster
 
Posts: 2
Default 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