vba to print pivot table

[adamheon]

i have this code that prints a range B5:K100. however it seems to have only worked the first time I used it...now as the pivot table changes, nothing changes on the PDF. which is really weird because i removed columns and the formatting of the pivot table...but when I prints a PDF none of the changes are made.

here's the code.

Please Login or Register  to view this content.

[GeneralDisarray]

You have that range hard coded here:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.