Thread: Would love to write macro to delete any row that DOESN'T containspecific text..
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John[_147_] John[_147_] is offline
external usenet poster
  
Posts: 4
Default Would love to write macro to delete any row that DOESN'T containspecific text..
On Jan 25, 4:51*pm, Don Guillett wrote:
Just use datafilterautofilterfilter with "contains"old
stuffdelete
record a macro if desired

On Jan 25, 10:44*am, John wrote:

Ah, but once the filter is applied it shows me the rows of data that
I want to keep, not delete.

Hmm... I wonder if there's a way to do an inverse selection.

Thanks
Reply With QuoteReply With Quote