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.