Oh, I see.

Make a print area. Go into Names:Define. Select the Print_Area name
and change its reference. Something like:

=INDIRECT("Sheet1!$A$1:$G$"&Sheet1!$H$1)

So it will print the columns through G and the rows through whatever
number is in H1. And then you put a formula to figure out the last row
in H1. You may be able to just plug that formula into the Name, as
well.