Category: Functions

0

VBA-Excel: Date-Time Functions – DateSerial()

Description: The DateSerial() function returns the Date type based on the parameters provided (year, month and date). Format: DateSerial(year,month,day) Arguments: Year Manda­tory Type: Numeric or Any Numeric Expression Between 100 and 9999, values between...

0

VBA-Excel: Date-Time Functions – DatePart()

Description: The DatePart() function returns the part of given date based on the parameters provided. Format: DatePart(interval,date[,firstdayofweek[,firstweekofyear]]) Arguments: interval Manda­tory Type: String expression The time interval you want as a part of given date

1

VBA-Excel: Date-Time Functions – DateDiff()

Description: The DateDiff() function returns the specified time interval difference between the two dates provided. Format: DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]]) Arguments: interval Manda­tory Type: String expression The time interval you want the difference between two dates.

10

VBA-Excel: Date-Time Functions – DateAdd()

Description: The DateAdd () function adds the specified time interval to the date and returns a Variant (Date) Format: DateAdd(interval,number,date) Arguments: interval Manda­tory Type: String expression The time interval you want to add

0

VBA-Excel: Date-Time Functions – IsDate()

Description: The IsDate() function determines whether expression can be converted into date and  returns the Boolean value based upon that. Format: IsDate(expression) Arguments: expression Mandatory Validate whether expression can be converted into date.

2

VBA-Excel: Array Functions – Filter()

Description:  Filter() Function returns one dimensional array containing the filtered array elements based upon the filter options provided Format: Filter(arrArrayName,FilterValue [, Include[, vbCompare]]) Arguments: arrArrayName Manda­tory Type: Array Array which needs to be filtered

0

VBA-Excel: Array Functions – Join() – Converts Array to String

Description:  Join () Function returns a String that consist of array elements separated by the delimiter provided. Format: Join(arrArrayName[,delimiter]) Arguments: arrArrayName Manda­tory Type: Array Array Name which needs to be converted into string.

2

VBA-Excel: Array Functions – LBound and UBound()

Description:  LBound and UBound() Functions returns the starting index ( Lower Bound) and Ending index (Upper Bound) of an array. Format: LBound(arrArrayName [, dimension]) UBound(arrArrayName [, dimension])   Arguments: arrArrayName Manda­tory Type: Array Array...

4

VBA-Excel: Array Functions – Split()

Description:  Split() Function returns one dimensional array containing the substrings, after splitting the main string based upon the delimiter provided. Format: Split(strMainString [, delimiter[,intlimit[, vbCompare]]]) Arguments: str­Main­String Manda­tory Type: String String which will be...

0

VBA-Excel: String Functions – String()

Description:  The String() function returns a string consisting a repeating characters of specified length. Format: String(number,character) Arguments: number Mandatory Type: Numeric No of times the character to be repeated, means length of the returned...

0

VBA-Excel: String Functions – strComp()

Description: The strComp() function compares the two strings and returns the comparison result in numeric form. Format: StrComp(string1, string2[, compare]) Arguments: String1 Mandatory Type: String First string which gets compared with another one

1

VBA-Excel: String Functions – Space()

Description: The Space() function returns a string consisting a specified number of spaces. Format: Space (intNumberOfSpaces) Arguments: intNumberOfSpaces Mandatory Type: Numeric Number of spaces you want in the string.

Show Buttons
Hide Buttons
%d bloggers like this: