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 vote258 views1 answer
Excel vba urlmon
VBA
0 vote242 views1 answer
Vbnet find highest value in chart
VBA
0 vote236 views1 answer
Show unix time in vba
VBA
0 vote239 views1 answer
Telephon call in vba
VBA
0 vote242 views1 answer
Set column width of datagridview vb.net
VBA
0 vote185 views1 answer
How to make a if statement with vbs
VBA
18 votes328 views3 answers
Excel-vba make integer
VBA
25 votes301 views2 answers
Excel vba folder exist
VBA
0 vote238 views1 answer
How to make a a msgbpx in vbs
VBA
3 votes247 views1 answer
Vba make long from two words
VBA