RosettaCodeData/Task/Array-length/VBA/array-length-2.vba

9 lines
217 B
Text
Raw Permalink Normal View History

2023-07-01 11:58:00 -04:00
Dim funkyArray(7 to 8) As String
Public Function SizeOfArray(ar As Variant) As Long
SizeOfArray = UBound(ar) - LBound(ar) + 1
End Function
'call the function
Debug.Print "Array Length: " & SizeOfArray(funkyArray)