Variables

VBA Split String into Array in Excel

VBA Split String into Array

VBA Split String into Array in Excel VBA Split String into Array in Excel is regular task in data analysis. In this tutorial we use Dim statement, VBA Split function, array and Delimiter. Dim statement is used to declare array and string type variable. Here not defining the array size. VBA Split function creates an …

VBA Split String into Array in ExcelRead More »

Keywords in VBA

VBA Keywords

Keywords in Excel VBA Keywords we use in MS Office Excel VBA (Visual Basic for Applications) programming language. These keywords are high light in blue color in visual basic editor window. We can’t use these keywords as function name or procedure name or variable name. Keywords in VBA plays an important role in VBA Programming …

Keywords in VBARead More »

Environment Variables in VBA

VBA Environment Variables

Environment Variables in VBA We have an environment block that contains a set of environment variables and their values. You can get at all the system information using VBA by using environment variables. Here are the different Environment variables, you can find the below table. These Environment variables especially useful when you want to know …

Environment Variables in VBARead More »