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 vote208 views1 answer
Vbnet find highest value in chart
VBA
0 vote230 views1 answer
Regex numeric digits
VBA
5 votes235 views1 answer
Excel vba left word from Long Integer
VBA
0 vote211 views1 answer
Excel run macro every 5 minutes
VBA
0 vote255 views1 answer
Vba excel parser xml
VBA
0 vote223 views1 answer
Vba listbox remove all items
VBA
0 vote213 views1 answer
Compare dates vb
VBA
0 vote210 views1 answer
Excel vba calculate
VBA
0 vote230 views1 answer
Sendkeys vba selenium
VBA
3 votes205 views1 answer
Excel vba read registry key value
VBA