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.
Setting this property to a negative value will result in a run-time error.
This example moves scrolls the currently selected cell in the detail area of PivotTable1 up by 15 pixels
PivotTable1.ActiveData.CurrentCell.DetailTopOffset = 15