I am working in Access 2010.
I need to determine if a variant is an array. I put together the following function:
Public Function IsArray(varIn As Variant) As Boolean
Dim i As Integer
On Error GoTo ExitFunction
i = UBound(varIn)
IsArray = True
On Error GoTo 0
It appears to work. Is there some unforeseen circumstance I'm not thinking of where this procedure wouldn't work?
Is there a better way to determine if a variant is an array?