Empty cell 0

[DQ1]

Mental block. Isn't there any easy way to fill all empty cells with
"0"'s?

 

[Bernie Deitrick]

DQ1,

Cells.SpecialCells(xlCellTypeBlanks).Value = 0

HTH,
Bernie
MS Excel MVP

 

[Paul Sheppard]

Mental block. Isn't there any easy way to fill all empty cells with
"0"'s?

Hi DQ1

You can enter a single zero just by typing into the cell, to enter
multiple 0's either enter a ' first, or format the cell as text first
and the enter as many 0's as you like

 

[Bernie Deitrick]

DQ1,

Mental block here: that is the VBA code that will do it (thought I was in .programming).

To do this manually, click the button to the upper left of cell A1 to choose all cells. Then use
Edit / Go To... Special Blanks. Then press 0, and press Ctrl-Enter.

Sorry for the confusion.

HTH,
Bernie
MS Excel MVP

DQ1,

Cells.SpecialCells(xlCellTypeBlanks).Value = 0

HTH,
Bernie
MS Excel MVP

 

[Jay]

Mental block. Isn't there any easy way to fill all empty cells with

"0"'s?

One way:

First type 0 in an empty cell and use
Edit > Copy

Then
Edit > Goto > Special > Blanks

Then
Edit > Paste