View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] BrianWest83@gmail.com is offline
external usenet poster
 
Posts: 4
Default Delete Rows based on cell value

Hi. I'm trying to create a macro that will delete rows where the
value in column E does not equal "ABC". I always have a different
number of rows of data so I can't use a fixed range. Also, rows 1-5
are my header rows so I don't want to touch them--so the macro should
start looking at column E in row 6 and continue until it hits a row
where column E is blank. Thanks in advance.