Variables or Arguments in Advance

VBA uses the Variant data type as the default data type for variables and arguments. The Variant data type permits Excel to switch between floatingpoint, integer and string variables as required. 

You can force a particular variable or argument to take a specified data type. For variables, use the Dim statement, e.g.. 

---