Tagged: Arrays

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

Show Buttons
Hide Buttons
%d bloggers like this: