Could someone help me with this problem. I have a sheet named "Employee Print Outs". It is set up to print out 32 pages. Page 1 starts in cell B6 and ends in cell S154. Page 2 starts in cell B155 and ends in cell S304. So each of the 32 pages has 150 rows of printing area. What I'd like to do is to print each page and have VBA to print these in a Portrait Orientation with no margins and to fit on the page. I could do this by setting the page break for each sheet needed but the issue is on each page rows could be hidden. For example, each page has 150 rows but page 1 might only have 100 rows showing, Page 2 might have 130 rows showing, page 3 might have 75 rows showing and so on.
Hopefully I've explained this well enough.
Thanks in advance
Excel 2016
Windows 7
Hopefully I've explained this well enough.
Thanks in advance
Excel 2016
Windows 7
