Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,592
- Office Version
- 365
- 2016
- Platform
- Windows
Ok, I think the bigger challenge here is to explain what I am looking to get done, so my apologies in advance if my explanation is lacking appropriate detail, or fails to utilize the appropriate terminology.
In my application, workbook (workbook1), worksheet(1) is populated with a series of ranges that represent, when printed, one 8.5"x11.5". There can be several pages represented, one below the other, on the worksheet.
In that same workbook, worksheet(2) is a static range that gets printed on the reverse side of each of the pages from worksheet(1).
What I find myself doing now, and I'm trying to make it a bit less reliant on the user, is print the pages in worksheet(1). At the printer, I put these sheets in the printer tray, and then print worksheet(2) x number of times to the preprinted pages in the printer drawer.
What code would one suggest I use in order to print worksheet(2) on the reverse of each page in worksheet(1) as it's printed without manually having to do adjust sheets and print seperately?
In my application, workbook (workbook1), worksheet(1) is populated with a series of ranges that represent, when printed, one 8.5"x11.5". There can be several pages represented, one below the other, on the worksheet.
In that same workbook, worksheet(2) is a static range that gets printed on the reverse side of each of the pages from worksheet(1).
What I find myself doing now, and I'm trying to make it a bit less reliant on the user, is print the pages in worksheet(1). At the printer, I put these sheets in the printer tray, and then print worksheet(2) x number of times to the preprinted pages in the printer drawer.
What code would one suggest I use in order to print worksheet(2) on the reverse of each page in worksheet(1) as it's printed without manually having to do adjust sheets and print seperately?
