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