Skip to main content

Posts

Showing posts from May, 2021

How to Declare Variable in Excel VBA

Struggling to know How  to declare a variable in Excel VBA??           Declaration of Variables means assigning types to the variables. There are many methods available in declaring variables in VBA. We can see them one by one. 1)     Casual declaration:                    Here there is no data type or must needed declaration on any data type is required on the variables in VBA.  Variable can be loaded as is.                      For Example:                                             a = 10                                             b = "Test" ...