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

3 votes165 views1 answer
Vba not equal
VBA
0 vote169 views2 answers
Get excel file from email attachment in vba
VBA
5 votes170 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote180 views1 answer
Vb.net change cursor to wait
VBA
0 vote180 views1 answer
Excel vba hide gridlines
VBA
5 votes187 views1 answer
Excel vba low word from Long Integer
VBA
0 vote171 views1 answer
Vba get workbook name
VBA
0 vote178 views1 answer
Vba type variable
VBA
0 vote196 views1 answer
If statement vdhl
VBA
3 votes167 views1 answer
Vba folderexists
VBA