How do I know if an array is empty or not?

[jesus4u]

Have you noticed that if you do the len() function on a filled array or if you do an ubound() function on an empty array you get errors?

How do I work around this?

thanks

[jesus4u]

I think isarray() will do it

[rjlohan]

The reason is that you're not using those functions on an empty array - you're doing it on an array you've only declared, but never used, or given size or data to.

[Arc]

Try this

Dim MyArray(10) As String
Dim Whole As String
Whole = Join(MyArray)
If Whole = Space(UBound(MyArray)) Then MsgBox "Array is Empty"

[jesus4u]

thanks for the input