The Range property returns the difference between the maximum and minimum data values in the column from which the statistics were calculated. Returns a variant. This is a read-only property.
Syntax
object.Range( Col )
|
Parameter |
Type |
Description |
|
Col |
Long |
optional, default=1 |
Example
This example demonstrates how to return the difference between minimum and maximum data values in column C .
Debug.Print "Range "; Stats.Range(3)
Used by: WksStatistics object