sayoung4517
New Member
I have three ranges a2: s18 u2:am18 and an2:be18.
I need to print the ranges on an 11x17 sheet of paper in landscape. I want the charts to be the right size. If I were to cut and paste and use shrink to fit I can fit 4 on each sheet. I have to do this for quite a few worksheets daily, so I would like to set up a macro to do this for me.
The key is I want the ranges to print in order with the second and third range below the first.
ANY help would be appreciated.
I need to print the ranges on an 11x17 sheet of paper in landscape. I want the charts to be the right size. If I were to cut and paste and use shrink to fit I can fit 4 on each sheet. I have to do this for quite a few worksheets daily, so I would like to set up a macro to do this for me.
The key is I want the ranges to print in order with the second and third range below the first.
ANY help would be appreciated.
Last edited: