View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default how can I delete rows based on column value

apply an autofilter to column C, filter on 0, and then just delete the
visible rows.

--
__________________________________
HTH

Bob

"mike" wrote in message
...
How can I delete certain rows of my worksheet that has a specific value in
a
specific column. For example, delete all rows that have a value of '0' in
column 'C'??

Mike