VBA Data Types of Variables
Important note before starting a code: (It is not mandatory to declare data type in VBA. When you did not declare the data type, VBA automatically considers the variable of the variant data type. “A variant data type can match to any data type”. This looks convenient not to declare the data type of variable, but it’s not the best practice to use a variant data type. The reason is that variant the data type takes up more memory and can make VBA code run slow, which means it takes more time to run the code.)
Let’s see...
Related: Excel VBA common basic questionsRelated: How to Record, Run and Save MacroRelated: How to add VBA to the Excel and common terms of VBA Written by: Kalpesh Agrawal (Actuarial Intern - IIB)