Cells Methods

The Cells method returns a range object containing one or more worksheet cells. Returns a WksRange object.

Syntax

object.Cells( 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 a set the background color of cells A1:E4 to red.

Wks.Cells(1, 1, 4, 5).Format.BackColor = grfColorRed

 

Used by: Worksheet object, WksRange object