If ... then or Select Case ?

[the old man]

Hi Guys,

Does anybody have experience which is quicker - long (If Then Else) construction or (Select Case) ?

Thanks in advance.

Regards

 

[RoryA]

I very much doubt you'd notice any difference. I recall reading many years ago that If...Then was slightly quicker but I suspect the difference would be negligible. It may depend on the nature of how the code is written though.