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

31 votes485 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
1 vote311 views1 answer
Ms access open form to new record
VBA
0 vote379 views1 answer
Vba parameter adodb null value
VBA
0 vote365 views1 answer
VBA is form loaded
VBA
0 vote364 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote352 views2 answers
Vba remove line breaks
VBA
22 votes743 views1 answer
Excel vba check if directory exists
VBA
0 vote404 views1 answer
Excel web scraping
VBA
0 vote333 views1 answer
Excel vba disable alerts
VBA
2 votes348 views2 answers
Vba code to remove duplicates from a column
VBA