Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
However, say, to avoid adding to an already large block of nested If's I
might use Goto to skip to the next section. Do you see anything intrinsically wrong in that type of use of GoTo. No, there is nothing intrinsically wrong with it at all... and many programmers use it just the way you describe. However, there are also lots of programmers, like me, who never use it at all. I have no trouble constructing, or reading, a long block of nested If-Then-ElseIf blocks, so that is what I prefer to do. To each his/her own. One note, however... if things are getting lengthy in a nested If-Then-ElseIf block, placing the active code in subroutines so that most levels are simply single line Call statements helps to make things more readable. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Continue" and Exit with For Loops | Excel Programming | |||
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab? | Excel Programming | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
Automatically click "Update Links" & "Continue" | Excel Programming |