Pivot Table VBA
 

with ActiveSheet.PivotTables("PivotTable").PivotFields( "sls_no")
.Orientation = xlRowField
.Position = 1

I am trying to figure out what code should be used to drag from the field
list into the pivot table. The code above does not work. Does anyone know the
correct code?

Thank you.

Pivot Table VBA
 

You could turn on the macro recorder as you manually drag the field into
the pivot table. Then, use the code that was created.

HELP wrote:
with ActiveSheet.PivotTables("PivotTable").PivotFields( "sls_no")
.Orientation = xlRowField
.Position = 1

I am trying to figure out what code should be used to drag from the field
list into the pivot table. The code above does not work. Does anyone know the
correct code?

Thank you.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html