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(Row:=1, Col:=1, LastRow:=25, LastCol:=3)
Used by: WksDocument object