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 vote144 views1 answer
Vba range clear formatting
VBA
2 votes134 views1 answer
Date format for ms chart vb.net
VBA
0 vote97 views1 answer
Vba code to remove leading and trailing spaces
VBA
1 vote135 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote147 views1 answer
Vba vbcrlf chr
VBA
3 votes135 views1 answer
Extract the nth word from a text string
VBA
0 vote173 views1 answer
Check if cell is dbnullvb.net
VBA
5 votes150 views1 answer
Excel vba low word from Long Integer
VBA
9 votes263 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote140 views1 answer
Refer to resource using string variable vb.net
VBA