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 vote265 views1 answer
If inputbox cancel vba
VBA
1 vote269 views1 answer
Excel vba unload userform
VBA
0 vote278 views1 answer
Excel vba DisplayAlerts
VBA
2 votes274 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote269 views1 answer
Remove frist letter from string vbnet
VBA
31 votes370 views1 answer
Vba how to convert a column number into an Excel column
VBA
2 votes259 views1 answer
Excel vba extract file name
VBA
0 vote273 views1 answer
Thread sleep vb
VBA
0 vote273 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
2 votes283 views1 answer
Excel vba check if string entirely alpha
VBA