View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andycharger[_17_] andycharger[_17_] is offline
external usenet poster
 
Posts: 1
Default 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