Code to Clear Contents if values is zero

[chico.corrales]

Hi,

is there a code to clear contents of a cell with zero values, i have a huge
excel file (15-16 MB) it has a lot of zero values i want to get rid off.


Thanks in advance.

[davesexcel]

Check out this thread from a few days ago

Edit the code to clear contents instead of Deleting Rows.

http://www.excelforum.com/excel-prog...66#post3200666

Attach a sample workbook if you can't get to work for your situation.

[chico.corrales]

Daveexcel,

i think this one will delete the entire row, i only want to delete/clear
the contents of specific cells w/ zero values.


Thanks,
Chico

[davesexcel]

Did you read my entire post?