If cell value is 0 - How can you make that cell blank?

[Larry]

I know this is an elementary question, but I am a very new developer with a very complex report to write. I am attempting to do this in a Macro and I am unsure of the code. I have referenced John Walkenbach's books, but I am still stumped.

Any info will be greatly appreciated.

 

[Larry]

On 2002-04-05 14:11, Larry wrote:
I know this is an elementary question, but I am a very new developer with a very complex report to write. I am attempting to do this in a Macro and I am unsure of the code. I have referenced John Walkenbach's books, but I am still stumped.

Any info will be greatly appreciated.

 

[Al Chara]

Try the following:

If ActiveCell.Value = 0 Then ActiveCell.Value = ""

I think this is what you want.

 

[daleyman]

you can hide all zero values by going into tools options and deselecting the "zero values" box. Or in VBA the equivilent is...


ActiveWindow.DisplayZeros = False


Or if you want to do it in vba for a single cell,

if range("a1")=0 then range("a1")=""

or...

if cells(rowx,colx)=0 then cells(rowx,colx)=""

 

[jreeper]

Cells.Replace "0", Null

 

[Larry]

Wow!! That was fast.

Thanks to all.