Automation Made Easy & Productive!
VBA Functions and Examples
VBA Loop Through all XLS Files in a Folder VBA Loop Through all xls Files in a Folder using built-in Dir() function. In this tutorial we loop through a folder or directory and list all available .xls files in a folder. Lets learn how to use Dir, Right and Len VBA functions in this tutorial. …
VBA Array Filter Function The filter function returns an array, which contains subset of string based on specified criteria. Table of Contents: Overview of VBA Filter Function in Excel Syntax of VBA Filter Function in Excel Includes all filtered strings – case sensitive Extract all filtered strings – not a case sensitive Excludes or doesn’t …
VBA Loop Through all Files in subfolders VBA Loop Through all Files in subfolders using File System Object(FSO) and built-in Dir() function. VBA for each file in subfolder macro helps us to loop through all files in subfolders. In this tutorial we loop through subfolders and list all available files in subfolders using FSO early-binding …
Currency Data Type in Excel VBA Currency Data Type in Excel VBA explained with syntax and examples. We use the Currency VBA data type to store numbers in integer format and these numbers scaled by 10,000. The default value is 0. The Currency VBA data type conatins range of values between -922,337,203,685,477.5808 to 922,337,203,685,477.5807. The …
Object Data Type in Excel VBA Object Data Type in Excel VBA explained with syntax and examples. An object consists of reference to an object. It occupies 4 bytes (32 bits) in memory. We use Set statement for a convenient way to refer an object. Table of Contents: Overview of Object VBA Data Type in …
Variant Data Type in Excel VBA Variant Data Type in Excel VBA explained with syntax and examples.Variant Data Type in Excel VBA explained with syntax and examples. It is a special and universal data type to use for any kind of data except fixed lenth string. It is more flexible, but occupies more space in …
String Data Type in Excel VBA String Data Type in Excel VBA explained with syntax and examples.String Data Type in Excel VBA explained with syntax and examples. Where string is nothing but sequence of characters. We use VBA data type string to store text. Text includes not only characters but also numbers, spaces and special …
Double Data Type in Excel VBA Double Data Type in Excel VBA explained with syntax and examples.Double Data Type in Excel VBA explained with syntax and examples. We use VBA data type Double to store numbers which represents Double-precision floating-point variables. The default value is 0 and store decimal values. The VBA data type Double …
Single Data Type in Excel VBA Single Data Type in Excel VBA explained with syntax and examples. We use VBA data type single to store numbers which represents single-precision floating-point variables. The default value is 0 and store decimal values. The VBA data type single conatins range of values -3.402823E38 to -1.401298E-45 for negative values, …
Date Data Type in Excel VBA Date Data Type in Excel VBA explained with syntax and examples. The Date VBA date type stores floating point numbers that represents date and time. We can store date, time or date and time. It has date range values from Jan 1, 0100 to December 31, 9999 and time …
Decimal Data Type in Excel VBA Decimal Data Type in Excel VBA explained with syntax and examples.Decimal VBA Data Type in Excel VBA explained with syntax and examples. We use the Decimal VBA data type to store integer numbers scaled by a variable power of 10. The default value is 0. The Decimal VBA data …
Long Data Type in Excel VBA Long Data Type in Excel VBA explained with syntax and examples. We use the long VBA data type to store whole integer numbers. It is an alternative to integer. It occupies more range than integrs. The default value is 0. The long VBA data type conatins range of values …
Boolean Data Type in Excel VBA Boolean Data Type in Excel VBA explained with syntax and examples. We use the Boolean VBA data type to store logical data. The Boolean VBA data type conatins only two states of values either TRUE or FALSE. In other words we can also refer as 1 for True and …
Integer Data Type in Excel VBA Integer Data Type in Excel VBA explained with syntax and examples. We use the integer VBA data type to store only integer whole numbers. The default value is 0. The integer VBA data type conatins range of values between -32,768 to 32,767. Integers cannot have decimal places. The integer …
Byte Data Type in Excel VBA Byte Data Type in Excel VBA explained with syntax and examples. It contains binary data and holds a value from 0 through 255. Byte type is categorized as a numeric data type. The default value of byte is 0. It is used to save space in memory. It is …
VBA Multi-Dimensional Array in Excel VBA Multi-Dimensional Array in Excel.The Multi-Dimensional Arrays uses more than two indexes(Subscripts). We can have up-to 60 dimensions in an array. Table of Contents: Overview of VBA N-Dimensional Array in Excel Syntax of VBA Multi-Dimensional Array in Excel Example for VBA N-Dimensional Array in Excel Instructions to use Macro Code …
VBA Three-Dimensional Array in Excel VBA Three Dimensional Array in Excel. The 3Dimensional Array has three dimensions and uses three indexes(Subscriptss). The three subscripts(indexes) are separated with comma symbol. For example one index represents the rows, second one represnts the columns and third one represnts the charts. We refer Excel worksheet or cudbe for 3Dimensional …
VBA Two-Dimensional Array in Excel VBA Two-Dimensional Array in Excel. Two Dimensional Array ahs two dimensions and uses 2 Indexes. The two indexes are separated with comma symbol. For example one index represents the rows and other represnts the columns. The 2Dimensional array also called as rectangular array. We refer Excel worksheet or table for …
VBA One-Dimensional Array in Excel VBA One-Dimensional Array in Excel. The One(1)-Dimensional Array uses only one index(Subscript). The one-dimensional array consists of list of items of same data type. It consists of either single row or column data. We read values from an array or into an array using index value. The one dimensional array …
VBA Array Erase Function VBA Array Erase Function in Excel. The Erase function is used to reset(reinitialise) the size of an array. It depends on type of an array . That is either static or dynamic array. Table of Contents: Overview of VBA Erase Function in Excel Syntax of VBA Erase Function in Excel VBA …