API reference

Arrays

Transform, filter, sort, and group Variant arrays in memory.

17 public procedures5 enumerationsNew Arrays

Functions and procedures#

Name	Description
`Exchange`	Swap two Variant values in the caller through ByRef arguments.
`DimCounter`	Probe array dimensions with UBound, up to the implementation's fixed limit of ten.

Name	Description
`SliceArray`	Extract a row or column from a 2D array while keeping a 2D result.
`Sort`	Stably sort a 1D array or the rows of a 2D array by one column.
`Filter`	Select rows using one or two criteria, combining them with AND or OR.
`Unique`	Return distinct values from the first column in first-appearance order.

Name	Description
`Transpose`	Swap the two dimensions of a 2D array using explicit VBA loops.
`DimReduce`	Convert a single-row or single-column 2D array into a 1D array.
`DimExpand`	Convert a 1D array into a 2D column array.
`DimSplit`	Convert a 2D matrix into a 1D outer array containing one 1D array per row.
`DimMerge`	Convert a 1D array of compatible 1D row arrays into a 2D matrix.
`Change_Lbound`	Rebase one dimension of a 1D or 2D array without changing its values or shape.

Name	Description
`InsertColumns`	Append columns to a 2D array or overwrite its trailing columns.
`InsertLines`	Append rows or overwrite trailing rows, interpreting a 1D array as one row.
`DeleteElement`	Remove one row or column from a 2D array and compact the remaining values.
`FillColumn`	Replace an existing column with values from a positional column vector.

Name	Description
`GroupBy`	Group rows by one key column and compute one aggregate from another column.

The class has VB_PredeclaredId = False. Use an instance, or a shared instance declared in a standard module.

Dim utility As Arrays
Set utility = New Arrays
' Existing project global instance: Arr