Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is quicker? Nested or non nested ifs
I have a set of conditions on my macro.
If it is one type, set the color background to "whatever" Then go on to the next if statement and do that colour. Im wondering if there is much of a performance gain over nesting the I statements or not? Would it take the same amount of time to run? IE If then else end if If then Else end if if then Else End if or If then else if else if else end if end if end if Any ideas -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested If | Excel Discussion (Misc queries) | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested if | Excel Worksheet Functions | |||
Nested IF | Excel Discussion (Misc queries) | |||
Nested If with And | Excel Worksheet Functions |