View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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