Vba len variant

Public Function ArrayLen(arr As Variant) As Long
    If IsEmpty(arr) Then
        ArrayLen = 0
    Else
        ArrayLen = UBound(arr) - LBound(arr) + 1
    End If  
End Function

Similar codes

1 vote351 views1 answer
Export datagridview to excel vb.net
VBA
0 vote346 views1 answer
Excel vba disable screen update
VBA
32 votes522 views2 answers
Excel vba column letter
VBA
0 vote374 views1 answer
Vba search string position
VBA
0 vote347 views1 answer
Date as number vb
VBA
1 vote321 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote325 views1 answer
Telephon call in vba
VBA
11 votes474 views1 answer
Excel vba How to URL encode a string
VBA
0 vote354 views1 answer
Vba integer to double
VBA
3 votes323 views1 answer
Excel vba read registry key value
VBA