MoveDetailTop Method
The document is archived and information here might be outdated

MoveDetailTop Method

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Scrolls the the detail area down starting at the specified cell.

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.


Use the MoveDetailLeft method to scroll the detail area to the left.


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


© 2016 Microsoft