Make zeroes in Selection nothing ""
Are they values or formulas?
If they're values:
Select the range and then
edit|replace
what: 0
with: (leave blank)
replace all
Make sure you match entire cell constants.
Record a macro when you do it manually and you'll have the code.
MikeF wrote:
My code navigates to and selects a range, then needs to change all zeroes to
blanks, nothing, "" .
Is there a quick trick to this that I'll slap my forehead over?
Thanx,
- Mike
--
Dave Peterson
|