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 vote159 views1 answer
Vb streamreader
VBA
0 vote158 views1 answer
Vba string
VBA
1 vote161 views1 answer
Add control vb
VBA
3 votes216 views2 answers
Excel "vba" match last value
VBA
11 votes317 views1 answer
Excel vba How to URL encode a string
VBA
0 vote167 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
5 votes161 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote152 views1 answer
Vba word pdf table to excel
VBA
0 vote182 views1 answer
Vba round to 2 decimals
VBA
0 vote162 views1 answer
How to use if condition in time vba
VBA