Range Method

The Range method returns a WksRange object containing one or more cells.

Syntax

object.Range( Row, Col, LastRow, LastCol )

 

Parameter	Type	Description
Row	Variant	required, row number in quotes
Col	Variant	optional, column letter in quotes
LastRow	Variant	optional, row number in quotes
LastCol	Variant	optional, column letter in quotes

 

Remarks

See Specifying Cell Coordinates for more information on selecting cells.

Example

This example demonstrates how to assign a range of cells to the variable named WksRange.

Dim WksRange As Object

Set WksRange = Wks.Range(1, 1, 25, 3)

 

Used by: Worksheet object