Dynamic Print Split Range

[melodramatic]

I am trying to set a dynamic print range, but one that takes a portion of the top of the sheet, and then adds on a portion of the bottom of the sheet. The portions depend on how many items are in a group.

If I manually set the print range, here's what I see when I go to the Print_Area in Formulas/Name Manager: '='L1'!$B$1:$X$126,'L1'!$B$243:$X$590

What I've got on the sheet, in calculated cells, gives the ranges I want:

Sheet L1, Cell AD1 (for the top portion of print): $B$1:$X$126
Sheet L1, Cell AD2 (for bottom portion of print): $B$241:$X$590

Now, for one range only (the standard that I've always used), what I've done in the past is go to my Print_Area, and change the Refers to: with an indirect command: =INDIRECT('L1'!$AD$1)

But, how do I do that with two sections to become what I need?

Thank you in advance for your help!

 

[melodramatic]

One note - I also tried to create a concatenation of the entire line shown in Print_Area (when manually choosing the area)

='L1'!$B$1:$X$126,'L1'!$B$243:$X$590 is what shows when I manually choose the area

'L1'!$B$1:$X$126,'L1'!$B$243:$X$590 is what I now have calculated in cell AF1 I then went to Print_Area, changing the Refers to: =Indirect("'L1'!$AF$1") And it doesn't work for me. I get the entire print out of all lines.