VBA Array Join Function in Excel

VBA Array Join function

VBA Array Join Function VBA Array Join Function in Excel. The Join function helps us to join sub strings in an array and returns a single string. It is an opposite of VBA Array Split function. We can also use ‘&’ operator to concatenate strings. It performs same like the join function. Table of Contents: …

VBA Array Join Function in ExcelRead More »

VBA Array IsArray Function in Excel

VBA Array IsArray function

VBA Array IsArray Function in Excel VBA Array IsArray function checks whether the specified input variable is an array or not. It returns a boolean value. The specified input varaible ia an array then returns True, otherwise returns False. Let us examples in the following tutorial. Table of Contents: Overview of VBA IsArray Function in …

VBA Array IsArray Function in ExcelRead More »

VBA Array UBound Function in Excel

VBA Array UBound function

VBA Array Upper Bound(UBound) Function Let us see about VBA arrays Upper Bound or UBound function in Excel VBA. The UBound function represents the Upper Bound value of an array. It returns the highest subscript(Index) value of specified array. It helps to determine the existing an array end size. Table of Contents: Overview of VBA …

VBA Array UBound Function in ExcelRead More »

VBA Array LBound Function in Excel

VBA Array LBound function

VBA Array Lower Bound(LBound) Function Let us see about VBA arrays lower bound or LBound function in Excel VBA. The LBound function represents the lower bound value of an array. It returns the smallest subscript(Index) value of specified array. It helps to determine the existing an array starting size. Table of Contents: Overview of VBA …

VBA Array LBound Function in ExcelRead More »

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 »

VBA to compile and collate Multiple excel workbooks and sheets data in one sheet in new excel file

VBA to compile and collate Multiple excel workbooks and sheets data in one sheet in new excel file Question: Hi… I’m looking for comment for below scenario. 1.  I have 3 excel file named ABC1, ABC2 and ABC3. 2.  I want to copy selected range of rows and column (it’s same for all the 3 …

VBA to compile and collate Multiple excel workbooks and sheets data in one sheet in new excel fileRead More »

VBA Cascading Dropdowns in UserForm

VBA Cascading Dropdowns in UserForm Question:I have 3 columns :region country product. I want to  have dependent dropdowns like countries population based on region selection and products population based on countries drop-down. Now here’s the most important part- This should be done using FORM CONTROL dropdowns and not combo boxes or data validation. Can …

VBA Cascading Dropdowns in UserFormRead More »

VBA Remove Spaces Between Characters and Numbers within Range in Excel

VBA Remove Spaces Between Numbers and Characters fi

VBA Remove Spaces Between Characters and Numbers within Range in Excel VBA Delete Spaces Between numbers and characters within range in Excel. We can use Find and Replace VBA functions to remove spaces completely between characters and numbers. Table of Contents: Overview Macro to Remove Spaces Between characters and Numbers within Range in Excel VBA …

VBA Remove Spaces Between Characters and Numbers within Range in ExcelRead More »

VBA Remove Spaces from String in Excel

VBA Remove Spaces from String fi

VBA Remove Spaces from String in Excel VBA Remove extra Spaces or blanks from String in Excel. Sometimes we may have more than one space in a string. To remove additional or extra spaces we use different VBA functions like LTRIM, TRIM, or RTRIM. We use LTRIM function to remove left most or starting of …

VBA Remove Spaces from String in ExcelRead More »

VBA Concatenate Strings in Excel

VBA Concatenate Strings

VBA Concatenate Strings in Excel VBA Concatenate Strings in Excel. We can Append multiple strings into single string by using ‘&’ and ‘+’ operators. All string values are enclosed with double quotation(“”) marks. We have to add space before and after & and + operators. We can append special symbols also. Table of Contents: Overview …

VBA Concatenate Strings in ExcelRead More »

VBA Month Number to Name in Excel

VBA Month Number to Name

VBA Month Number to Name in Excel VBA convert Month Number to Month Name using Excel VBA Functions. Convert or change Month Number to Name using Excel VBA MonthName function function. Table of Contents: Overview Macro to Convert Month Number to Name in Excel VBA Instructions to use Macro Related VBA Functions used in this …

VBA Month Number to Name in ExcelRead More »

VBA Month Name to Number in Excel

VBA Month Name to Number

VBA Month Name to Number in Excel VBA convert Month Name to Month Number using Excel VBA Functions. Convert or change Month Name to number using VBA DateValue function and VBA Month function. Table of Contents: Overview Macro to Convert Month Name to Number in Excel VBA Instructions to use Macro Related VBA Functions used …

VBA Month Name to Number in ExcelRead More »

Calculate Quarters Between two Dates in Excel VBA

Calculate Quarters Between two Dates

Calculate Quarters Between two Dates in Excel VBA Calculate Quarters Between two Dates in Excel VBA using VBA formulas. We use DateDiff VBA Function to determine the number of Quarters between two dates. In order to calculate number of Quarters between two dates we need start date and end date. It returns an integer value …

Calculate Quarters Between two Dates in Excel VBARead More »

Calculate Minutes Between two Times in Excel VBA

Calculate Minutes Between two Dates

Calculate Minutes Between two Times in Excel VBA Calculate Minutes Between two Times in Excel VBA using VBA formulas. We use DateDiff VBA Function to determine the number of Minutes between two Times. In order to calculate number of Minutes between two Times we need start time and end time. It returns an integer value …

Calculate Minutes Between two Times in Excel VBARead More »

Calculate Seconds Between two Times in Excel VBA

Calculate seconds Between two times

Calculate seconds Between two Times in Excel VBA Calculate seconds Between two Times in Excel VBA using VBA formulas. We use DateDiff VBA Function to determine the number of seconds between two Times. In order to calculate number of seconds between two Times we need start time and end time. It returns an integer value …

Calculate Seconds Between two Times in Excel VBARead More »

Calculate Weeks Between two Dates in Excel VBA

Calculate weeks Between two Dates

Calculate weeks Between two Dates in Excel VBA Calculate weeks Between two Dates in Excel VBA using VBA formulas. We use DateDiff VBA Function to determine the number of weeks between two dates. In order to calculate number of weeks between two dates we need start date and end date. It returns an integer value …

Calculate Weeks Between two Dates in Excel VBARead More »

Calculate Years Between two Dates in Excel VBA

Calculate Years Between two Dates

Calculate Years Between two Dates in Excel VBA Calculate Years Between two Dates in Excel VBA using VBA formulas. We use DateDiff VBA Function to determine the number of Years between two dates. In order to calculate number of Years between two dates we need start date and end date. It returns an integer value …

Calculate Years Between two Dates in Excel VBARead More »

Calculate Months Between two Dates in Excel VBA

Calculate Months Between two Dates

Calculate Months Between two Dates in Excel VBA Calculate Months Between two Dates in Excel VBA using VBA formulas. We use DateDiff VBA Function to determine the number of months between two dates. In order to calculate number of months between two dates we need start date and end date. It returns an integer value …

Calculate Months Between two Dates in Excel VBARead More »