| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null Field Result in Loop
As part of a larger macro I am running the following loop.
For ILoop = NumRowsF850 To 1 Step -1 If Cells(ILoop, 5) = 0 Then Rows(ILoop).Delete End If Next ILoop When the loop gets to a cell that is null, it is evaluating the the second line of code as true, i.e. the cell = 0. I only want to branch to the "Then" part of the loop if the cell truly has a 0 in it, not if it is null. How should the second line be written? TIA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to use a different cell if my date field is NULL/BLANK | Excel Worksheet Functions | |||
| How do I get Null as a result of an if? | Excel Discussion (Misc queries) | |||
| How do I set a result of an "if" function to NULL; not 0 or ""? | Excel Worksheet Functions | |||
| if A1=Null and B1=A1 why is result in B1=0 ?? | Excel Discussion (Misc queries) | |||
| select column cell in same row as loop result? | Excel Programming | |||
Threaded Mode
