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 vote239 views1 answer
Loop through all text boxes in a form vb
VBA
18 votes319 views3 answers
Excel-vba make integer
VBA
0 vote241 views1 answer
Supprimer la valeur de celule vba
VBA
5 votes231 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote257 views1 answer
Make your computer talk vbscript
VBA
0 vote237 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote245 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote224 views1 answer
Excel vba disable mouse click
VBA
0 vote252 views1 answer
Columns dont autoresize on program start vb.net
VBA
2 votes190 views1 answer
Excel vba pause
VBA