View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jonathan Jonathan is offline
external usenet poster
 
Posts: 138
Default Selecting Rows based off certain criteria and deleting all others

Hi all,

I have a large population of data that needs to be sorted by certain
criteria, and I'm not all too great with macros, so if anyone could please
assist, that'd be great.

All I need to do for right now is remove all the rows that have no
highlighting in any of the columns. I've already gone through and
auto-filtered certain values that need to be analyzed, but there are
thousands of rows that didn't meet any of the criteria, so I'd like to remove
them. Is there a simple macro I can run that will search all 7 columns of
each row, and if none of them are highlighted, they will be deleted?

Thanks,

Jonathan