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 vote170 views1 answer
Return na vba
VBA
0 vote174 views1 answer
Vba variable number of arguments
VBA
0 vote188 views1 answer
Excel vba first column in range
VBA
0 vote184 views1 answer
VB get external IP address
VBA
0 vote172 views1 answer
Change whcih control a user has selected vb
VBA
18 votes241 views2 answers
Vba make word from bytes
VBA
3 votes199 views2 answers
Vba date to string
VBA
0 vote186 views1 answer
Excel vba urlmon
VBA
3 votes186 views1 answer
Vba not equal
VBA
0 vote168 views1 answer
Vba declare 64-bit ptrsafe
VBA