How can I determine the length of a variant array. If it contains data then this is no problem (Ubound - Lbound) but if it has not been initialized then ubound returns subscript out of range. A work around is :
i = 0
On Error Resume Next
i = UBound(vIDs) - LBound(vIDs)
On Error GoTo 0
If i > 0 Then
but this seems quite inelegant. Is there
some better way ?