VBA IsArray Function

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

The Excel VBA IsArray function returns True if the variable provided is an array. It will return False otherwise.

VBA IsArray Function Syntax

The syntax for the IsArray function in VBA is:
function examples:

where Variablecan be any type of variable

Example usage of VBA IsArray

To see more tips and trick with VBA Arrays see my tutorial otherwise below a few examples:

As you noticed the VBA ReDim statement above allows you to redefine the size of an existing array or redefine a Variant as an array.

Simply the best place to learn Excel VBA