Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It's not about the number of lines following the label. In general GoTo
statements are not recommended at all, except for On Error GoTo ... to handle error trapping. GoTo statements are throwbacks from the '40s (Fortran). They tend to make code less readable than using If-Then-Else or calling subroutines and functions, but once in a while they can be used. In all of my libraries I have only one old function I can think of where I used GoTo's not in error trapping. It is a Heap Sort that proved to run faster with GoTo's than two other versions where the GoTo's were replaced with more structured code. Other than that, GoTo's are Gone. "Laurie" wrote: Thanks for all your quick responses and very helpful suggestions!!!!!! I need time to digest the ideas but I can see some way to solve the problem now. So, goto statement is universally not recommended if multiple statements need to be put under the label line? Thanks, Laurie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
? IF and GOTO ? | Excel Worksheet Functions | |||
Goto | Excel Programming | |||
Goto statement in an IF function | Excel Worksheet Functions | |||
On Error Goto doesn't goto | Excel Programming | |||
On Error Goto doesn't goto | Excel Programming |