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 vote188 views1 answer
Vba excel parser xml
VBA
0 vote174 views1 answer
Open application from vbnet
VBA
5 votes184 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote185 views1 answer
How to format a textbox as date vb net
VBA
0 vote186 views1 answer
Vba string
VBA
0 vote185 views1 answer
Excel vba copy range with filter
VBA
0 vote196 views1 answer
Vba first cell in range
VBA
0 vote178 views1 answer
Putting marquee in vb.net
VBA
0 vote182 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote183 views1 answer
Vbnet line graph smooth lines
VBA