Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill in the blanks!!
Hi All,
I have a range of cells (i.e. A1: D5), some of which contain values and others that are blank. I want to create a piece of code that looks in each cell of the range. If the cell is blank, then insert a 0, and if the cell contains a value then ignore it and move on to the next cell. Can anyone help at all? Thanks, Pinda. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill in the blanks!!
Try this
On Error Resume Next Range("A1:D5").SpecialCells(xlCellTypeBlanks).Valu e = 0 On Error GoTo 0 -- Regards Ron de Bruin http://www.rondebruin.nl "Bhupinder Rayat" wrote in message ... Hi All, I have a range of cells (i.e. A1: D5), some of which contain values and others that are blank. I want to create a piece of code that looks in each cell of the range. If the cell is blank, then insert a 0, and if the cell contains a value then ignore it and move on to the next cell. Can anyone help at all? Thanks, Pinda. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fill up blanks | Excel Discussion (Misc queries) | |||
Fill Blanks Macro | Excel Discussion (Misc queries) | |||
Fill in the blanks! | Excel Programming | |||
Fill in the blanks | Excel Programming | |||
Fill in the blanks | Excel Programming |