Macro to print Page view

Jetx227

Board Regular
Joined
Jul 11, 2018
Messages
96
Hey guys, I'm not great at macros but I can imagine there is one that can help me, I'm just not sure how to make it. This will be a bit hard to explain because I'm not sure how to share a workbook on this forum so if someone can explain how to do that real quick it'll save a lot of trouble (sorry I'm still a bit new here).
I have this workbook that has like 150 sheets that all have a set up to look like a standard 8.5 x 11 page for easy print. the only thing is I don't want to go through each sheet and select the data to do it. The sheet lengths vary too, some may have 1 page and others 10 pages. This became an issue because some of the longer sheets started getting cut off when I hit the print active sheet option. Any help would be greatly appreciated! Thanks in advance!
(P.S. If someone already posted something like this I apologize, I searched around a bit and didn't see a forum with it, but if you find it and link it that would be perfect too.)
 
Last edited:

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,128,078
Messages
5,628,527
Members
416,323
Latest member
65563

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top