Run time error 1004 at pdf print

[abraham30]

Hello Everyone

I have taken the code of this forum from google and try to resolve one issue but not succeed.

My requirement is to print all data into pdf in the attached spreadsheet.
When I have define the particular column range, I m not getting any issue. The error appears in variable range.

Is it possible to print the same data to ms word document format (along with pdf)

Advance thanks