• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 572
  • Last Modified:

VBA to print pivot table

I have a pivot table called StructurPivot, How should vba code to print this pivot table look like?
0
hallpett
Asked:
hallpett
1 Solution
 
hallpettAuthor Commented:
Found solution:
    ActiveSheet.PivotTables("StructurPivot").TableRange1.Select
    Selection.PrintOut Copies:=1, Collate:=True
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now