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 vote391 views1 answer
Excel vba first column in range
VBA
0 vote361 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote377 views1 answer
Excel last used row
VBA
0 vote376 views1 answer
Add text to combobox drop down vb
VBA
7 votes379 views1 answer
Vba array declaration
VBA
0 vote382 views1 answer
Vba sort the data Z to A
VBA
0 vote356 views1 answer
Vba remove numbers from string
VBA
0 vote375 views1 answer
Vba round to 2 decimals
VBA
0 vote368 views1 answer
.net dark title bar
VBA
0 vote391 views1 answer
Vba parameter adodb null value
VBA