Fill empty cells
 

I am new to VBA code for excel, and here is my situation. I have
written a macro and the last part of my macro is to check for the
following:

I have a range of cells I have selected, and I need to look throughout
this range and see if there is any empty cells, if there is...I have
to fill it with a zero (0) . Does anyone have any code that would
help me here? Thanks

M.

Fill empty cells
 

Put this in your macro:

For Each c in Selection.Cells
If c.Value = Empty then c.Value = 0
Next


Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=544739

Fill empty cells
 

Thanks soooo much...