Quote Originally Posted by Paul_Hossler
If you have a lot of If-Then / ElseIf-Then .... a Select Case would inprove the readability, and possibly a slight increase in performance if it was being executed a gazillion times in a loop.

Paul
LOL, I just knew it was either a bajillion or gazillion, just couldn't recall which.

Quote Originally Posted by sam314159
Trust me GTO, no one here is closer to a laymen level in VBA programming than me

I think you are 100% correct, I am running it both ways and I can not see any difference in performance.

I thought the fact that my second condition was a pretty complex function that goes through multiple loops and calculations to get a result would slow things down.

Still kinda of curious as how it's really done and if I do undestand it correctly, I wonder why that's done.

That's like saying, my car won't run because it's on fire but I still need to check the tire pressure to see if I can drive it.

By the way, these kinds of threads are what you get when you let engineers with no programming experience run rampant in VBA forums!
I'm not exactly sure what you are asking. How to nest IFs or ??? I certainly would look at Select Case as Paul mentioned.

No problems as to asking questions. Shucks, I have and continue to learn a lot here, and while I've probably hesitated from asking something I 'just know' is simple, when I do, even if I have to repeat the question (like: "Can you explain that again, only in realllly small words?"), someone almost always takes the time and is patient. It is a great place.

A great weekend to all,

Mark