Print Macro for Range Defined in Cell

Hello,
I am trying to put a print macro into a worksheet. What makes this unique is that the sheet will have 3 different print areas that I need to account for (all 8.5 x 11).
The sheet is still a work in progress and may change so the most flexible way would be to have a cell on the sheet (AL5) where I can put in the print area manually (or by formula) and the macro will pick this up as the print area.

For instance, I would like the value in cell AL5 to be “B7:H70”. The macro would then find this range and print 8.5x11 of this range. I would then have another print macro in the same worksheet that would reference a different range in AL6, (say J5:V66)

Is this an easy solution? Thank you in advance.

? Try:

Please Login or Register  to view this content.

Hi Porucha! Thank you for the reply. My apologies for lack of understanding macro language. I've attached a scaled down version of the workbook I am working in. The idea is that the worksheet (123-Main) will be copied and pasted numerous times so the macro needs to be for the active sheet. A button for each print area per sheet can work. (The attached shows the buttons). The ranges for each section are in AL5-AL7. Is there a way that the macro can reference these cells and use the values in these cells to determine the print range?

Thank you again for the reply.

or try this:

Please Login or Register  to view this content.

Thank you Bakerman2. I like this macro but the manual entry for print range will not work for this application since there may be up to 30-40 of these worksheets.

Hi Porucha,
This is closer to what I am looking for. One issue appears that if I try to adjust the ranges in say cell AL5 to say B7:V76 (as a pressure test), the print does not expand to that range. It seems the existing range that can be seen when one hits the "Page Break Preview" overrides this new range in cell AL5. (changing print area 3 to include more rows seems to work though). Thoughts?

Thanks