expression.MoveDetailTop(DetailTop, DetailTopOffset, Update)
expression Required. An expression that returns a PivotCell object.
DetailTop Required Long. An index number indicating the cell to use as the basis for scrolling. For example, use a value of 5 to start the scrolling at the sixth row in the detail area.
DetailTopOffset Required Long. The number of pixels to scroll. Use 0 to scroll the record specified in the DetailTop argument to the top of the detail area.
Update Optional Boolean. Determines whether or not the display is updated. The default value is True.
Remarks
Use the MoveDetailLeft method to scroll the detail area to the left.
Example
This example scrolls the fifteenth row to the first row displayed in the detail area.
Sub ScrollDetailArea()
Dim ptData
Dim pmColumnMember
Dim pmRowMember
Set ptData = PivotTable1.ActiveData
Set pmRowMember = ptData.RowAxis.Member
Set pmColumnMember = ptData.ColumnAxis.Member
' Starting at the 15th row of the detail area, scroll 100 pixels.
ptData.Cells(pmRowMember, pmColumnMember).MoveDetailTop 15, 0
End Sub