get Data Type of Variable in VBA – VarType() VBA function

Dear Friends, Some time during the VBA programming you may need to perform different action based on "what is the type of the variable" you are dealing with. Or in other words what kind of data is stored in a variable. In VBA, if you have not defined type of a variable while declaring it using "Dim statement", then whatever [...]

VBA String Functions – INSTR() Function

Instr() Function This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value. As mentioned in the definition of this function, it always returns the position number [...]