IF AND IF OR SELECT CASE... wath the best solution

[sal21]

In the "If and If" condition i have variuos OR.
In order of speed time code wath is the best sultion from If And If or Case Select

[HansV]

I did some tests, but execution speed seems to be about the same. If you have a lot of consecutive single conditions, If is slightly faster, and if you have lots of multiple conditions with Or, Select Case is slightly faster, but the differences are very small.

[StuartR]

I think that you should choose which to use based on readability of the code. This can make a very big difference in the long term and will be much more significant than tiny performance differences.