View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Would love to write macro to delete any row that DOESN'T containspecific text..

On Jan 25, 10:55*am, John wrote:
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



does NOT
< contain