Application.Cells (Excel)

Returns a Range object that represents all the cells on the active worksheet. If the active document is not a worksheet, this property fails.

Because the Item property is the default property for the Range object, you can specify the row and column index immediately after the Cells keyword. For more information, see the Item property and the examples for this topic. Using this property without an object qualifier returns a Range object that represents all the cells on the active worksheet.


Dim rngCells As Range
Set rngCells = Cells