Pivot Table VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically run a macro everyday 6
VBA Pivot Table Error 1
Adding PivotTable fields with a macro 3
MACRO FOR PIVOT TABLE 2
Format Pivot total rows 2
pivot tables macro 14
Playing back a Pivot Table macros 2
please suggest....pivot table not getting created 1

Back
Top