Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a block containing several levels of nested statements within a For
Each...Next loop. I'm using a GoTo statement to make execution jump to the end of the loop. It works, but I'm wondering if there isn't a better way to do this, because I've read that you should not use line numbers to jump around inside a subroutine. Any ideas? Here's the structure of the code: For Each X in Range("TickerList") If .... With ..... Select Case True Case ... Case ... If .... GoTo 15 'from here i want to jump to Next X End If End Select End With End If Next X |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
nested IF statements | Excel Worksheet Functions | |||
nested if statements | Excel Worksheet Functions | |||
Nested if statements - is there a better way? | Excel Worksheet Functions | |||
Nested If Statements | Excel Worksheet Functions | |||
Nested If/Then statements | Excel Worksheet Functions |