Posted by Trevor Best on 11/22/05 21:10

Terry Kreft wrote:
> If it's a variant array that wouldn't work e.g.
>
> Dim Arr ' i.e. a variant
>
> Which at some later point is assigned a value such as
>
> Arr = Array(1, 2)
>
> After this line IsArray would return true, before this line it would return
> false. Before this line Ubound(Arr) raises the error the OP has seen after
> it the error is not raised, hence the reccomendation to use IsArray.

I'll repeat:
Personally, I'd look at the Dim statement so see if was an array :-)

i.e. I would never write code like that.

[Back to original message]