Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)

Excel VBA Tutorials

It’s best practice to declare your Excel VBA variables before you use them. Declaring variables means that you give VBA a heads up that it needs to free up some memory space for your variables which will in most cases be less than the default.

Credit Leila Gharani