Worksheet.Cells (Excel)

Returns a Range object that represents all the cells on the worksheet (not just the cells that are currently in use).

Because the default member of Range forwards calls with parameters to the Item property, you can specify the row and column index immediately after the Cells keyword instead of an explicit call to Item. 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 = ActiveSheet.Cells