print pdf from pivot getting run time error 1004

[abraham30]

Hello Everyone

I want to print the data of HCP sheet into both pdf and document format.

I manage somewhat for pdf. Can anyone help me how can it be possible

Please note that the pivot table is auto-refreshed (both row and column are in variable range) and also the title border(fill color) is changing continuously

Details:--
PrintArea---row and column with variable range

PrintTitleRows---$1:$10

CenterFooter = &P/&N

Advance thanks for your support

[:) Sixthsense :)]

Slight changes in your code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[abraham30]

Thank you very much for your great help. I need one additional help.

Is it possible to print the same data also in doc format along wiht pdf when the macro run.

Advance thanks