Automatically Print Once Dynamic Print Range is Identified

[ccowman]

Hi everyone,

I have a workbook with 12 sheets that are reports for a specific team. Within each tab, there are four separate sections of reports. What I'd like to do is have the user click on a button directly above each section and be able to print out what is in that section (in total, there will be 48 buttons, but each prints a different section). Right now, I have the code to identify the print range, but I'm unsure how to add the print range macro(s) to a larger print function. Any help would be greatly appreciated. Thanks!

Also, below is the code for the four sections for one team to identify the print area.

Please Login or Register  to view this content.

[ccowman]

Hi,

Just curious if anyone had any thoughts. Basically, I want to click a button and print an area that has a dynamic range, which is identified via the SetPrintRange macros above. Thanks for any help in advance!

[barryleajo]

Perhaps define a sub like:

Please Login or Register  to view this content.

and call it from your code like:

Please Login or Register  to view this content.

or if you didn't want the print dialogue box perhaps use the Worksheets.PrintOut method something like:

Please Login or Register  to view this content.

[ccowman]

Works perfect, @barryleajo! Thanks so much! I'll mark as solved.