Blank Cells in A Range default to O?

kotting · Apr 26th, 2002, 03:43 AM

I have a range E42:BL42 which users input a number (I used validation here). My problem is that the cell can remain empty. By backspacing, the cell can be empty. In this circumstance I want the (ONLY THE) blank cells to be filled with a 0.

I tried using:

range("E42:BL42").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1="=0"

with no success. I also tried:

Edit|GoTo|Special|Blanks and enter "=0"

this did not produce the results I need either. I know this is probably an easy fix but it's escaped me. Thanks for all the help!

Mudface · Apr 26th, 2002, 04:03 AM

Have you tried Edit-find and replace?

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

Apr 26th, 2002, 03:43 AM	#1
kotting New Member Join Date: Mar 2002 Posts: 17	I have a range E42:BL42 which users input a number (I used validation here). My problem is that the cell can remain empty. By backspacing, the cell can be empty. In this circumstance I want the (ONLY THE) blank cells to be filled with a 0. I tried using: range("E42:BL42").Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection.FormulaR1C1="=0" with no success. I also tried: Edit\|GoTo\|Special\|Blanks and enter "=0" this did not produce the results I need either. I know this is probably an easy fix but it's escaped me. Thanks for all the help!

Apr 26th, 2002, 04:03 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Have you tried Edit-find and replace?