Fri 5 Aug 2011, 10:24Delegate Tony said...
Tony has attended:
Excel VBA Advanced course
Excel VBA
What is the code to activate a drop down in the 'page' section of a pivot table, then choose an item from the list?
Thu 11 Aug 2011, 15:07Trainer Anthony said...
RE: Excel VBA
Hi Tony, thanks for your query and apologies for the delay. If you had a "Model" field in the page section, you'd manipulate it and choose the "Corvette" option like so:
ActiveSheet.PivotTables("PivotTable1").PivotFields("Model").CurrentPage = "Corvette"
Hope this helps,
Anthony
