Array "defined"???

[jcagle]

In VBA, is there a way to tell if an array as been ReDim'd somewhere along the line? For example:

Dim Array() as Variant

If (a > b) then
ReDim Array(3)
End If

If (defined(Array)) then
' Do some stuff
End If

Thanks in advance!!

 

[venkat1926]

a good tutorial on array

http://www.anthony-vba.kefra.com/vba/vbabasic3.htm#Creating_and_Managing_Array

 

[wongm003]

You can use the Ubound function... if the array has been ReDim it will return the upper index...

Public Sub array_test()
'if an error occurs ignore error and continue
On Error resume Next

    Dim Ar() as Variant 

    If (a > b) then 
        ReDim Ar(3) 
    End If 

    'Note if a subscript was not assigned to the array an
    'error (9) will be triggered.

    If Ubound(Ar)=3 then 
        ' Do some stuff 
    End If