Andy,

The problem with former way is that is every IF test is evaluated, even
after one has matched. The latter avoids this, so on the basis of
probability, it is more efficient. Also, it reads better IMO.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"andycharger " wrote in message
...
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 IF
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/