Hi
just check that you want to match the whole cell

--
Regards
Frank Kabel
Frankfurt, Germany
"One-Leg" schrieb im Newsbeitrag
...
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???