| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Better way for writing IF statement ?
Hello;
Is there a better (more intelligent) way of writing the following sample single-line IF statement in Excel VBA procedure (macro): IF myVar1 = 1 And myVar1 < 100 And myVar1 < 25 And myVar1 <= Index Then GoTo myLable rather than repeating the same variable name over and over and over again ?? Does With structure allow comparison operators ?? Thank you kindly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NEED HELP WRITING IF STATEMENT | Excel Discussion (Misc queries) | |||
| Writing IF Statement | Excel Worksheet Functions | |||
| writing a statement | Excel Worksheet Functions | |||
| Help writing an IF statement | Excel Worksheet Functions | |||
| need help in writing a statement | Excel Programming | |||
Threaded Mode
