Functions

VBA Functions and Examples

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 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 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 »

Calculate Difference Between two Times in Excel VBA

Calculate Difference Between two Times

Calculate Difference Between two Times in Excel VBA Calculate Difference Between two Times in Excel VBA. Most of the time we wanted find differences of two Times. It’s a very regular and common exercise in Excel and VBA when dealing with times. We can find this using Excel VBA DateDiff function. In order to calculate …

Calculate Difference Between two Times in Excel VBARead More »

Calculate Difference Between two Dates in Excel VBA

Calculate Difference Between two Dates FI

Calculate Difference Between two Dates in Excel VBA Calculate Difference Between two Dates in Excel VBA. Most of the time we wanted find differences of two dates. It’s a very common and regular excercise in Excel and VBA when dealing with dates. We can find this using Excel VBA DateDiff function. In order to calculate …

Calculate Difference Between two Dates in Excel VBARead More »

Get Previous Date using VBA Functions

VBA Get Previous Date

Get Previous Date using VBA Functions Get Previous Date using Excel VBA Functions. Date plays an important major role in data analysis to summarize data, to create graphs and dashboards based on date. We also format date using format function in multiple ways. Table of Contents: VBA Get Previous Date using VBA Functions Macro to …

Get Previous Date using VBA FunctionsRead More »

Get Previous Year using VBA Functions

VBA Get Previous Year

Get Previous Year from Date using VBA Functions Get Previous Year from Today’s Date and specified date using Excel VBA Functions. Year plays an important major role as part of date. It helps in data analysis to summarize data, to create graphs and dashboards. We also format year using format function in two ways either …

Get Previous Year using VBA FunctionsRead More »

Get Current Year using VBA Functions

VBA Get current Year

Get Current Year from Date using VBA Functions Get Current Year from Today’s Date using Excel VBA Functions. Year plays an important major role as part of date. It helps in data analysis to summarize data, create graphs and dashboards. We also format year using format function in two ways either two year digit(xx) or …

Get Current Year using VBA FunctionsRead More »