Cells Property
Office 2003
Returns a Range object that represents the cells in the object.
expression.Cells
expression Required. An expression that returns one of the above objects.
Returns a PivotCell object based on a row and column member.
expression.Cells(Row, Column)
expression Required. An expression that returns one of the above objects.
Row Required PivotRowMember object. The specified row.
Column Required PivotColumnMember object. The specified column.
Example
This example sets the value of cell B3 to 5.
Spreadsheet1.Range("A2:C4").Cells(4).Value = 5
This example clears all cells on Sheet1.
Spreadsheet1.Worksheets("Sheet1").Cells.Clear
Applies to | PivotData Object | PivotRange Object | Range Object | Spreadsheet Object | Worksheet Object
