Check if a Dynamic Array has been ReDim'ed...

[MattKlein]

Is there a method built into VBA to check if a dynamic array has already be dimensioned? (I'm pretty new to VB and VBA) I am currently using

[vba]
if join(MyArray) = "" then
[/vba]

However, it feels sloppy and causes unneeded overhead on large arrays. True, I could have a boolean value keep track if its been ReDim'ed, but that isn't piratical if I'm passing an array to a function when that array may not have been initialized.

Thoughts?

[Bob Phillips]

[vba]


Function IsArrayAllocated(Arr As Variant) As Boolean
On Error Resume Next
IsArrayAllocated = Not (IsError(LBound(Arr))) And _
IsArray(Arr) And _
(LBound(Arr) <= UBound(Arr))
End Function
[/vba]