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

This should do it



sub blah()

for each rng in activesheet.usedrange

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

next rng
end sub

Thank you, I will give it a go!