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

1 vote186 views1 answer
Excel vba last row of range
VBA
0 vote172 views1 answer
Vb check if row has column
VBA
0 vote185 views1 answer
Worksheet.pastespecial textbox
VBA
5 votes192 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
5 votes196 views2 answers
Excel vba write to the windows registry
VBA
0 vote183 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote163 views1 answer
Vba word pdf table to excel
VBA
1 vote171 views1 answer
VBA Loop through recordset
VBA
5 votes189 views1 answer
Excel vba left word from Long Integer
VBA
0 vote201 views1 answer
Excel vba DisplayAlerts
VBA