vba len variant

The solution for “vba len variant” can be found here. The following code will assist you in solving the problem.

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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts