In this section you can find VBA functions and subroutines to operate on array.

The functions are listed below:

• Function to check if the given parameter is an array with dimensions declared (isDefinedArray)
• Function to check if the given parameter is a dynamic array (isDynamicArray)
• Function to check the number of dimensions of the given VBA array (countDimensions)
• Function to count the number of items in the given array (countArrayItems)
• Function to transpose the given array (transposeArray)
• Function to sort the given 2D array in the specified order (sortArray2D)
• Function to join the given arrays into single array (joinArrays)
• Function to sort the given 1D array in the specified order (sortArray1D)
• Function to check if the specified value is contained in the given array (isInArray)
• Function to add the given value to the 1D array (addEntry)
• Function to return the size of the given array in the specified dimension (arraySize)
• Function to return unique values from the given 1D array (uniqueValues)
• Function to convert the given array of any type or primitive value into array of strings (convertToStringArray)
• Function to convert the given value into 2D array (to2DArray)
• Function to filter the given 2D array by the specified value (filterArray)
• Function to filter the given 2D array by the specified value (addColumns)
• Function to convert the given array to string (arrayToString)
• Function to return the headers of the given 2D array as a dictionary (getArrayHeadersAsDictionary)
• Function to return a single column from the given 2D array as a 1D array (getArrayColumn)
• Function to remove the specified columns from the given 2D array (removeColumns)
• Function to remove all the empty rows from the given 2D array (removeEmptyRows)
• Function to paste the given data into the given Excel worksheet (pasteData)
• Function to create 1D array of strings (createStringArray)