Signature (Visual Basic / VBA)
Public Function Maximum( _
ParamArray vValues() As Variant _
) As Variant
Code Example
Maximum(56, 12, 34) = 56
Maximum(45, Array(12, 56, 78)) = 78
Maximum(SampleData) = 215
Parameters
| Parameter | Description |
|---|---|
| vValues | The arguments whose maximum value is to be returned. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays, or any combination of these. The current setting of the StatVarType Property determines which numeric data types are recognized by this function. |
Return Value
Function returns the maximum numeric value among all its arguments. Function returns Null if none of the arguments are numeric.
Notes & Version History
| v1.5 Note | This function replaces the MaxRealRecursive and MaxRealRecursiveArray functions, which have been removed from ArrayArithmetic Class. This function is slightly different in that it examines all of the elements in the array from its lower bound through its upper bound. |