• Kalpesh Agrawal

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 questions
Related: How to Record, Run and Save Macro
Related: How to add VBA to the Excel and common terms of VBA                

Written by: Kalpesh Agrawal (Actuarial Intern - IIB)


Recent Posts

See All