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 vote216 views1 answer
Vbnet click on dgv cells
VBA
0 vote214 views1 answer
VBA Loop to range
VBA
0 vote202 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote225 views1 answer
For each item in folder outlook vba
VBA
0 vote203 views1 answer
Excel vba hide gridlines
VBA
0 vote208 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote225 views1 answer
Find if year is leap year vb
VBA
0 vote202 views1 answer
Vbscript abs
VBA
0 vote195 views1 answer
Vba leading zeros in string
VBA
0 vote143 views1 answer
Vba select file in folder
VBA