| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill empty cells
Thanks soooo much...
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill down empty cells at every change in value | Excel Worksheet Functions | |||
| Excel - Fill empty cells | Excel Worksheet Functions | |||
| I need to fill only empty cells in a database with a symbol. | Excel Discussion (Misc queries) | |||
| Fill empty cells | Excel Programming | |||
| Fill-in empty cells from SAP report | Excel Worksheet Functions | |||
Hybrid Mode
