That won't work; only blanks need to be selected, which is the reason for
the Edit | GoTo.

--

Vasant


"Ralph Winchell" wrote in message
...
It's not necessary to go through the Edit / Go To... steps. Selecting a
range, typing 0 and hit CTRL-ENTER is sufficient.



"Ken Wright" wrote in
:

No need for code - Select the entire range, do Edit / Go To / Special
/ Blanks, then type 0 and hit CTRL+ENTER.