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 vote234 views1 answer
Vba check 32 or 64 bit
VBA
0 vote253 views1 answer
Vbnet click on dgv cells
VBA
0 vote242 views1 answer
Find days in month vba
VBA
0 vote253 views1 answer
Excel vba named range exists
VBA
4 votes250 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote257 views2 answers
S yyyy-MM-dd em vb net
VBA
5 votes240 views1 answer
Xl vba double quotes in string literal
VBA
0 vote234 views1 answer
Excel vba copy entire sheet paste values
VBA
1 vote249 views1 answer
Excel vba array remove first
VBA
27 votes505 views2 answers
Vba check if file exists
VBA