Range Property

Range 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 .

Dim WksRange As Object

Set WksRange = Wks.Range(Row:=1, Col:=1, LastRow:=25, LastCol:=3)

Used by: WksStatistics object