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 vote297 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
1 vote323 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
2 votes308 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote307 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
5 votes357 views1 answer
Xlvba double quotes in string literal
VBA
0 vote335 views1 answer
Excel vba copy range with filter
VBA
0 vote286 views1 answer
Excel vba disable copy paste
VBA
0 vote309 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote371 views1 answer
Visual basic cmd
VBA
0 vote316 views4 answers
How to continue formula in below line in vba code
VBA