Max
Description
The Max() method returns the largest value in a list of values. If no argments are passed the Max() method will use the stored array. Returns Empty if array is uninitialized, or only contains non-scalar variables. If operating on a jagged or multi-dimensional array, the value returned will be the largest value in all of the arrays combined.
Note
Multi-dimensional arrays assigned to the .Items property are converted to jagged arrays internally and will be treated as such by the Max() method.
Syntax
expression.Max([Args1[, Args2[, …[, ArgsN]]]])
Parameters
- Name
Args- Type
- ParamArray
Variant - Necessity
- Opional
- Description
- A list of values or an array to compare. If no arguments are provided the
Max()method will return the largest value on the stored array.
Returns
- Type
Variant- Description
- The largest value in the array.
Example
Public Sub MaxExample()
Dim result As Long
Dim MyArray As BetterArray
Set MyArray = New BetterArray
MyArray.Push 10, 1, 3, 5, 9, 12, 2, 8, 7
result = MyArray.Max()
' expected output:
' result = 12
End Sub