Danny's VBA Scripts

IsArray Function Named Arguments

• Get Everify To Uncover The Truth About Someone
• Project Management Template Kit

Syntax

IsArray( varname) varname

Use: Required

Data Type: Any

The name of the variable to be checked. Return Value Boolean (True or False). Description

Tests whether a variable is an array. Rules at a Glance

If the variable passed to IsArray is an array or contains an array, True is returned; otherwise, IsArray returns False.

Programming Tips & Gotchas

Due to the nature of variants, it isn't always obvious if a variant variable contains an array, especially if you pass the variant to a function, and the function may or may not attach an array to the variant. Calling any of the array functions, such as

IsArray Function 389

LBound or UBound, or trying to access an element in an array that doesn't exist will obviously generate an error. In these situations, you should first use the IsArray function to determine if you can safely process the array.

+1 0

Average user rating: 5 stars out of 1 votes