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