Thread: delete rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jack Sons
 
Posts: n/a
Default delete rows

Hi all,

I have some 500 rows. I want to delete all rows, except row 1, of which col
G is zero or blank while col A shows anything else than a string of which
the first character is S or P.

In other words, I want to keep row 1 and all rows in which col A shows text
starting with S or P and all rows not having zero or blank in col G.

I need the fastest code possible, my do loop takes a lot of time. I thank
you in advance for your assistance.

Jack Sons
The Netherlands