I am trying to print a cell range with a macro. I have 6 different sections
that need to be printed but not at the same time and not all with one button.
Here is the info.

Page that macro will be on is called "Input"
Page with the information needing to be printed is called "Reports"
the cell ranges are as follows
A4:AZ20
BI4:DH20
DQ4:FP20
FY4:HX20
A26:AZ42
BI26:BX41

I would like each report to print centered vertical and horizontal, and
shrink to fit page. There is also a header that needs to print with each
section. Thanks in advance.

Record a macro to set the print area to one of the print regions, do all the
formatting, and print it. You will then have code that you can amend for all
regions.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Agasnine" wrote in message
...
I am trying to print a cell range with a macro. I have 6 different
sections
that need to be printed but not at the same time and not all with one
button.
Here is the info.

Page that macro will be on is called "Input"
Page with the information needing to be printed is called "Reports"
the cell ranges are as follows
A4:AZ20
BI4:DH20
DQ4:FP20
FY4:HX20
A26:AZ42
BI26:BX41

I would like each report to print centered vertical and horizontal, and
shrink to fit page. There is also a header that needs to print with each
section. Thanks in advance.