Adding new workbooks

Hi John

Thanks for getting in touch, good to hear from you.

As a general guide, I would consider the IF... THEN when I have 3 or fewer options to choose between.

Any more than that, and I would use the SELECT CASE. It is easier to read and arguably write (for humans). I haven't seen any direct research comparing the speed of the methods.

The only possible downside to SELECT CASE is that you have to test the same object in every scenario. Most of the time you will be doing that but it's worth bearing in mind if your IF decision has to branch out and test different objects conditionally.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector