Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

MoveDetailLeft Method

Scrolls the detail area to the left starting at the specified column member.

expression.MoveDetailLeft(DetailLeft, DetailLeftOffset, Update)

expression   Required. An expression that returns a PivotColumnMember object.

DetailLeft  Required Long. An index number indicating for the cell to use as the basis for scrolling. For example, use a value of 2 to start the scrolling at the third column in the detail area.

DetailLeftOffset  Required Long. The number of pixels to scroll.

Update  Optional Boolean. Determines whether or not the display is updated. The default value is True.

Example

This example scrolls the detail area to the left by 10 pixels starting at the second column.

Sub ScrollDetailColumns()

    Dim ptData
    Dim pmColumnMember

    Set ptData = PivotTable1.ActiveData

    Set pmColumnMember = ptData.ColumnAxis.Member

    ' Scroll the first column in the detail area
    ' the left by 10 pixels.
    pmColumnMember.MoveDetailLeft 1, 10

End Sub

 

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.