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 vote304 views1 answer
Remove last 8 characters from string vb
VBA
0 vote291 views1 answer
Average vba
VBA
0 vote292 views1 answer
Excel vba remove formatting from cell
VBA
0 vote286 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote283 views1 answer
Replace spaces with underscores vbnet
VBA
1 vote286 views1 answer
Vba optional
VBA
0 vote266 views1 answer
Vbnet add new ecel sheet
VBA
0 vote290 views1 answer
Get current year vb
VBA
1 vote293 views1 answer
Random number generator vb.net
VBA
0 vote312 views1 answer
Move bindingnavigator vb
VBA