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 vote215 views1 answer
Vba first cell in range
VBA
5 votes248 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote223 views1 answer
Enter into cells data grid view
VBA
0 vote223 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote230 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote208 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote216 views1 answer
Vba add shape oval
VBA
0 vote231 views1 answer
Excel delete ever other vba
VBA
0 vote283 views1 answer
Vba excel do not recalculate before save
VBA
0 vote236 views1 answer
Excel vba prevent saving workbook
VBA