Hi, I have a workbook example but no code yet, just after some ideas. Worksheet 1 contains about 600 rows and worksheet 2 contains about 50. What I would like to do is set a print area range to say (70 Rows) then if the print area is greater than 70 Rows it would place the next part of the area on to the next new page, make sense?
Bookmarks