Hello,

Using Edit/Replace does the same thing...

"Frank Kabel" wrote:

Hi
then use 'Edit - Replace' for this

--
Regards
Frank Kabel
Frankfurt, Germany
"One-Leg" schrieb im Newsbeitrag
...
Hello,

I have many cells with numbers in them and many come up with only a "0" in
them. I want to use a macro that will see the value of the cell and if it
is
"0", then I would like to clear the cell. If it's anything else than "0",
nothing should be done!!!

Thanks

"Frank Kabel" wrote:

Hi
what are you trying to achieve ?

--
Regards
Frank Kabel
Frankfurt, Germany
"One-Leg" schrieb im Newsbeitrag
...
Hello,

I'm using the following in a macro but it doesn't work:

Range("A2:A65536").Select
If Cells.Select = "0" Then Selection.ClearContents

What should I change???