What is the syntax to see if something is an array?

IsArray(<variable name>)
‘example
Dim myArray1, myArray2 As Variant
myArray1 = Array(1,2,3,4,5)
myArray2 = 1

MsgBox(IsArray(myArray1)) ‘returns true
MsgBox(IsArray(myArray2)) ‘returns false

 

Advertisements