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

0 vote153 views1 answer
Vba type variable
VBA
0 vote156 views1 answer
Vba vbcrlf chr
VBA
2 votes153 views1 answer
Vba file from path
VBA
0 vote149 views1 answer
Vba collection contains
VBA
8 votes170 views1 answer
Excel vba make integer
VBA
0 vote158 views1 answer
Vba listbox remove all items
VBA
0 vote142 views2 answers
Get excel file from email attachment in vba
VBA
5 votes175 views1 answer
Excel vba get user selected range
VBA
0 vote143 views1 answer
How to extract a file from an ISO:
VBA
0 vote137 views1 answer
Le contrôle SpinButton (Toupie)
VBA