Re: ArrayHasElements - anything better than this?
Here's what I've used for years. The comparison between UBound & LBound is the key. If its empty then LBound is the greater of the two. Of course, you have to check that it is an array 1st.
Public Function aEmpty(aArray As Variant) As Boolean
On Error GoTo GetOut
aEmpty = True
If IsArray(aArray) Then
If LBound(aArray) <= UBound(aArray) Then
aEmpty = False
End If
End If
GetOut:
End Function