Print multiple worksheets to a single pdf file vba

I know the code needs cleaning up somewhat and would also appreciate some help there too. Have you tried setting the print area to D1:M90, insert horizontal page breaks at the appropiate rows and hide the rows you don't want to print?

Reset back to regular after printing. See if you can play with this to make it work. The first two lines are because of a problem with page breaks in excel.

Anyway I'm using the VBAexpress code to do it for me. To continue this discussion, please ask a new question. Get answers from your peers along with millions of IT pros who visit Spiceworks.

Merge" Anyone have any ideas how to get this to work or a way to print multiple reports into single pdf file? Thanks for any help. Best Answer. Thai Pepper. Alec This person is a verified professional. Forums New posts Search forums. What's new New posts New Excel articles Latest activity. New posts. Excel Articles Latest reviews Search Excel articles.

Log in Register. Search titles only. Search Advanced search…. Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser.

My 10 minute google search offered no quick solutions. Suddenly, I stopped looking for a VBA solution. The above quote flashed through my mind. Excel more often than not can do what you want without writing new VBA code.

I only needed 5 PDF files. Why not use Excel to simply produce the files manually. I did the following:. Set the print area for all 3 worksheets with a 3-line VBA code snippet. Select the three worksheets by holding down the CTRL key while clicking each worksheet with the mouse left button.