I have a spreadsheet with a defined header and column headings which
prints on each report. What I need to do is only select say rows 48 and
49 and print them (with the set header and column info) and then on a
separate page, print rows 79 through 85 (with the set header and column
info).

The only way I can do this so that the information shows up right under
the column heading info, is to change the SET PRINT AREA and select the
rows I need. This creates an additional step.

I would like to be able to highlight rows 48 and 49 and hit print and
it prints my report with the header and column headings and with just
the data from rows 48 and 49. This goes to one person. I would then
highlight rows 79-85 and hit print and it would print the info from
just those rows under the colunm headings.

Is it possible to skip the SET PRINT AREA each time I print?


NOTE:
If I do not set the print area, the rows I select print way down on the
page or on a second page.
Thanks