| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Handling Null Field in Macro Loop
The following loop is part of a larger macro.
For ILoop = NumRowsF850 To 1 Step -1 If Cells(ILoop, 5) = 0 Then Rows(ILoop).Delete End If Next ILoop If I find a null cell in the loop on line two, it is evaluated as 0 and the code branches to the third line. I do not want to execute the third line of code if the cell is null. How do I need to re-code line two to avoid this problem? TIA. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Handling Null Field in Macro Loop
Ken wrote:
How do I need to re-code line two to avoid this problem? Please see response to thread started 10 mins earlier. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Handling Null Field in Macro Loop
Sorry about the multiple posts. The website kept telling me the message
wasn't sent. "Ken" wrote: The following loop is part of a larger macro. For ILoop = NumRowsF850 To 1 Step -1 If Cells(ILoop, 5) = 0 Then Rows(ILoop).Delete End If Next ILoop If I find a null cell in the loop on line two, it is evaluated as 0 and the code branches to the third line. I do not want to execute the third line of code if the cell is null. How do I need to re-code line two to avoid this problem? TIA. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a Error Handling for this Macro | Excel Discussion (Misc queries) | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| I want to use a different cell if my date field is NULL/BLANK | Excel Worksheet Functions | |||
| Error handling in macro | Excel Discussion (Misc queries) | |||
| Null Field Result in Loop | Excel Programming | |||
Linear Mode
