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.

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