Name
IsArray Function
Syntax
IsArray(varname)-
varname Use: Required
Data Subtype: 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
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 whether
you can safely process the array.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access