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 vote192 views1 answer
Vba set vs dim
VBA
1 vote236 views1 answer
Excel vba unload userform
VBA
1 vote223 views2 answers
Vba string to date
VBA
0 vote243 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote316 views1 answer
Excel vba delete columns in range
VBA
1 vote239 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote245 views1 answer
Returns an array from function vba
VBA
0 vote241 views1 answer
Make all controls in an area not visable vb
VBA
0 vote231 views1 answer
Change whcih control a user has selected vb
VBA
0 vote231 views1 answer
Excel vba current folder
VBA