Saving as PDF once macro end of table

[VitaVela]

Hello All!

I've found such great help here before, I hoping I am lucky enough to again.


I have a macro that generates 3 tickets per sheet until it reaches the end of the table . It is currently set up to print each page as it cycles through. (I hope that makes sense)

I'd like to save all sheets to one PDF. I've figured out how to save each individually sheet as a PDF but can not figure out how to combine all. Please see code below and excel file. Thanks

Please Login or Register  to view this content.

[Winon]

Hello VitaVela,

I don't think you can expect a response from any Forum Member, since; Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

Regards.

[VitaVela]

Thanks for the information Winon. I hope I've adequately addressed.

[hashtag]

something like this?

Please Login or Register  to view this content.

[VitaVela]

Thanks Hashtag!

Not quite. I did a poor job of explaining what I was looking for. What you provided saves the entire workbook.

I only want to save the "macro" sheet after my initial macro runs.(which should generate several pages.)


Thanks for your help!