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.)
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:
