Quick Macro

[SteveChubb]

Good Afternoon,

Could someone please tell me if there is a quick macro that can be written that looks at all cells on a worksheet and runs a delete on all cells that contain just a zero value.

I can hide them using format 0;-0;;@ but this does not solve my problem.

Many thanks
SteveChubb

 

[chergh]

This should do it

sub blah()

for each rng in activesheet.usedrange

if rng.value = 0 then rng.value = ""

next rng
end sub

 

[SteveChubb]

Thank you, I will give it a go!