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

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

I think isarray() will do it

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.

Try this

VB Code:

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

thanks for the input