Build Macro to Print

[estrauss22]

I currently have a report that is feed by a pivot table. Each time you change the filter on the pivot table, new data comes up and alters the report. What I would like to do is be able to print a series of different reports, each with a different filter. I've tried to build a macro that would go through and select the various filters I want and print them, rather than having to manually select the filters each time I open the file. The problem I am having is that whenever I initiate the macro, it will not clear what was already selected in the report. I have various people, printing various reports and each time they print, whatever data was last loaded by the previous user is present on the new report as well. Is there a code I can write that would allow me to start with a clear pivot table each time?

 

[ravishankar]

HI
Try inserting this code before next report is generated.
Range("A1:Z250").clearcontents
Ravi

 

[estrauss22]

When I do the clear contents code - it deletes the entire page (included the pivot table) I need to keep the pivot, clear the filters, and start fresh.

 

[ravishankar]

Hi
I gave a hypothetical range as A1:Z250. You have adjust it to delete what you don't need. I wouldn't have a clue where your pivot tables appear.
Ravi