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 vote201 views1 answer
For each item in folder outlook vba
VBA
0 vote174 views1 answer
Excel vba disable screen update
VBA
1 vote208 views1 answer
Perform http request in vb.net
VBA
11 votes406 views1 answer
Excel vba How to URL encode a string
VBA
0 vote197 views4 answers
Jwt token vb.net validation
VBA
3 votes189 views1 answer
Vba make long from two words
VBA
0 vote191 views4 answers
How to continue formula in below line in vba code
VBA
0 vote185 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote180 views1 answer
Excel text to columns line break
VBA
0 vote199 views1 answer
Excel vba convert cells address
VBA