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

Larry · Apr 5th, 2002, 03:11 PM

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 · Apr 5th, 2002, 03:12 PM

Quote:

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 · Apr 5th, 2002, 03:12 PM

Try the following:

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

I think this is what you want.

daleyman · Apr 5th, 2002, 03:14 PM

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 · Apr 5th, 2002, 03:16 PM

Cells.Replace "0", Null

Larry · Apr 5th, 2002, 03:17 PM

Wow!! That was fast.

Thanks to all.

Apr 5th, 2002, 03:12 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following: If ActiveCell.Value = 0 Then ActiveCell.Value = "" I think this is what you want. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 03:11 PM	#1
Larry New Member Join Date: Apr 2002 Location: Plano, Texas Posts: 29	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.

Apr 5th, 2002, 03:14 PM	#4
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	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)=""

Apr 5th, 2002, 03:16 PM	#5
jreeper New Member Join Date: Apr 2002 Location: Kansas Posts: 5	Cells.Replace "0", Null

Apr 5th, 2002, 03:17 PM	#6
Larry New Member Join Date: Apr 2002 Location: Plano, Texas Posts: 29	Wow!! That was fast. Thanks to all.