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

3 votes120 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote125 views1 answer
Excel vba prevent saving workbook
VBA
0 vote120 views1 answer
Thread sleep vb
VBA
0 vote125 views1 answer
Vba full date format
VBA
0 vote131 views1 answer
Vba find last column in a row with data
VBA
0 vote144 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote122 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
7 votes122 views1 answer
Excerl vba array to range
VBA
0 vote122 views1 answer
Internet explorer reference vba
VBA
1 vote133 views1 answer
What does vbs stand for
VBA