|
|
Posted by Terry Kreft on 10/22/17 11:32
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.
--
Terry Kreft
"Trevor Best" <nospam@localhost.invalid> wrote in message
news:4381c70a$0$23296$db0fefd9@news.zen.co.uk...
> Terry Kreft wrote:
>> As others have said this is a SQL group but having said that the answer
>> is probably that Arr is not an array.
>>
>> Have a look at the IsArray function to test for this before using the
>> Ubound function.
>
> Personally, I'd look at the Dim statement so see if was an array :-)
Navigation:
[Reply to this message]
|