Range, Spreadsheet, or Worksheet object: Returns a Range object that represents the cells in the object. This property has no arguments when used with any of these three objects. Read-only.
Because the Item property is the default property for the Range object, you can specify the row and column index numbers immediately after the Cells keyword (this actually calls the Item property of the Range object returned by the Cells property).
PivotData object: Returns a PivotCell object based on a row and column member.
Syntax
expression.Cells(Row, Column)
expression An expression that returns a PivotData object.
Row Required PivotMember object. Specifies the row containing the returned cell.
Column Required PivotMember object. Specifies the column containing the returned cell.