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

1 vote124 views1 answer
VBA Loop through recordset
VBA
5 votes132 views1 answer
Excel vba high word from Long Integer
VBA
8 votes148 views1 answer
Excel vba make integer
VBA
0 vote130 views1 answer
Vb test if reference is null
VBA
0 vote133 views1 answer
Vba boolean to string
VBA
0 vote134 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote124 views1 answer
Excel vba hide columns
VBA
0 vote178 views1 answer
Excel vba protect content
VBA
0 vote175 views1 answer
Excel vba add reference programmatically
VBA
8 votes209 views1 answer
Vba make integer
VBA