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 vote224 views1 answer
Add control vb
VBA
0 vote237 views1 answer
Weekday vba
VBA
3 votes229 views1 answer
Extract the nth word from a text string
VBA
1 vote2K views1 answer
Vba Remove Case Sensitivity
VBA
0 vote224 views1 answer
Vb streamreader
VBA
0 vote216 views1 answer
Add items to combobox vb.net
VBA
0 vote218 views1 answer
Excel vba current folder
VBA
0 vote244 views1 answer
Excel vba first column in range
VBA
0 vote245 views1 answer
Vba code to select image in sheet
VBA
0 vote287 views1 answer
Excel vba paste all to each sheet in workbook
VBA