View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sojo Sojo is offline
external usenet poster
 
Posts: 21
Default Macro Delete cell if value

Hello Community:

I several columns of data. I need an excel macro that will look at a
specified column (I:I) and delete all cells that are a value I specify.
Each column of data will have a different criteria, so I'll just paste one
code after the next and change the column name and criteria.

I've looked through the discussion and can only find code to delete entire
row. I tried to modify the code to just delete cells and it did not work.

Can anyone help?

Thanks!