| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next inside If
I have something like
For Each cel in Sheets("Mate").Range(A1:A10000).Cells If IsEmpty(cel.Value) then Next cel If ...... ..... End If Next cel This fails with a "Next without For" message. To make it work I have changed the code to For Each cel in Sheets("Mate").Range(A1:A10000).Cells If IsEmpty(cel.Value) then GoTo MyLabel If ...... ..... End If MyLabel: Next cel But I wonder if it can be done, without the GoTo statement? Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Several AND operators inside an IF... | Excel Programming | |||
| I need to use more than 7 formulas inside each other | Excel Discussion (Misc queries) | |||
| 2 cells inside of one | New Users to Excel | |||
| add inside borders | Excel Discussion (Misc queries) | |||
| trying to email .xla inside/with .xls | Excel Discussion (Misc queries) | |||
Threaded Mode
