Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a Worksheet_Change sub that originally had several levels of If
statements to do different things with different ranges ("If Application.Intesect(Target,Range("A1:A10")) Is Nothing Then" ...). It was making my head hurt to keep all of them straight, so I switched to using GoTo statements, so I could separate the code for different ranges. Then I read that using multiple GoTo statements is frowned upon as bad practice, because it makes the code difficult to read. I wanted to get the opinions of some experience programmers. Any thoughts? ~ Horatio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested If's | Excel Worksheet Functions | |||
Nested If's | Excel Worksheet Functions | |||
How many nested IF's??? | Excel Discussion (Misc queries) | |||
Sorry about the last ones...And statements with IF's | Excel Programming | |||
NESTED IF's too many | Excel Programming |