DetailTopOffset Property

Microsoft Office Web Components Object Model

DetailTopOffset Property

       

Returns or sets a Long value that represents the number of pixels that the specified cell in the detail area is offset to the top. Use this property to move a cell in the detail area upward. Read/write.

expression.DetailTopOffset

expression   Required. An expression that returns a PivotCell object.

Remarks

Setting this property to a negative value will result in a run-time error.

Example

This example moves scrolls the currently selected cell in the detail area of PivotTable1 up by 15 pixels

PivotTable1.ActiveData.CurrentCell.DetailTopOffset = 15