Is an array empty???

[HeSaidJoe]

kedeman's way or this way, similar.
ceri's tested ok as well

Jop, courchjo, Megatron's will creat an error
on execution of code.

'Check to see if an array is empty
'avoid error on trying to view

On Error GoTo QuitNow:

Debug.Print UBound(myArray)
On Error GoTo 0
Exit Sub
QuitNow:
Debug.Print "Error,no dimension for array!"

[Edited by HeSaidJoe on 01-12-2001 at 12:01 PM]