Delete (Clear) Zero values only wita VBA

[Sahak]

Hi All,

I have database (about 100 rows & 20 columns) and they contains just 0 (zeros) and different numbers, including numbers with zeros, for example 60. I would like to delete (clear) numbers which has zero values only, not zero from 60, which will change its value from 60 to 6. Is there any solution without Looping?

A B C
40 0 0

to be
A B C
40

Thank you in advance

 

[mrhstn]

You can do this by matching the entire cell contents in a find/replace

Range("A2:K102").Replace What:="0", Replacement:="", LookAt:=xlWhole

 

[Sahak]

Very good. Thank you very much.