There is no discussion of performance in those articles.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Amit Shanker" wrote in message
...
Syed, you may want to take a look at the following urls for
more on this
topic :
http://www.ozgrid.com/News/ExcelSele...Dfunctions.htm
http://www.ozgrid.com/News/SelectCase2.htm
Amit
"Chip Pearson" wrote in message
...
I'd be interested why he came to his conclusion. I do agree,
however, with his statement that the difference is negligible
unless you have many, many, logic tree.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Syed Zeeshan Haider"
wrote in message
...
But "xlbo" is saying something different. What do you
think?
--
Syed Zeeshan Haider.
http://szh.20m.com/
-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"
"Chip Pearson" wrote in message
...
Syed,
Some quick and dirty testing shows that If/Then/Else is
about
twice as fast as Select Case.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Syed Zeeshan Haider"
wrote in message
...
Hello Everybody,
I have Excel 97 Pro on Win98SE.
For a certain situation, I have two options:
1. If Else
2. Select Case
I just want to ask which one of these is faster?
Thank you,
--
Syed Zeeshan Haider.
http://szh.20m.com/
-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"