Arrays Functions

ARRAYReturns an array containing the given values (Variant).
ERASEReinitialises the elements of an array.
FILTERReturns an array containing a subset of values that contain a substring (Variant).
ISARRAYReturns the value True or False depending if the expression is an array (Boolean).
JOINReturns a text string containing all the elements in an array (String).
LBOUNDReturns the smallest subscript in a given dimension of an array (Long).
REDIMInitialises and resizes a dynamic array.
SPLITReturns an array containing a specified number of substrings (Variant).
UBOUNDReturns the largest subscript in a given dimension of an array (Long).
ARRAY
Returns an array containing the given values (Variant).
ERASE
Reinitialises the elements of an array.
FILTER
Returns an array containing a subset of values that contain a substring (Variant).
ISARRAY
Returns the value True or False depending if the expression is an array (Boolean).
JOIN
Returns a text string containing all the elements in an array (String).
LBOUND
Returns the smallest subscript in a given dimension of an array (Long).
REDIM
Initialises and resizes a dynamic array.
SPLIT
Returns an array containing a specified number of substrings (Variant).
UBOUND
Returns the largest subscript in a given dimension of an array (Long).

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top