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 vote216 views1 answer
Vba string
VBA
0 vote206 views1 answer
Vbscript Trim
VBA
0 vote240 views2 answers
Excel vba number format file size
VBA
0 vote211 views1 answer
Vba round to 2 decimals
VBA
2 votes211 views1 answer
Vba split string
VBA
0 vote196 views1 answer
Vba copy paste value only
VBA
0 vote226 views4 answers
How to continue formula in below line in vba code
VBA
0 vote213 views1 answer
Excel vba show developer tab
VBA
0 vote200 views1 answer
Vb streamreader
VBA
0 vote216 views1 answer
Nested if else in vb.net
VBA