Hi,
Sheet1, Cell A1 has letter A.
Sheet2, Cell A1 has letter B.
When Print is selected for Entire Workbook, A is printed on page 1 and B is printed on page 2.
Is there a way to "force" the print such that A is printed on page 1 and B is printed below A on page 1?
If VBA is the best solution, kindly provide the code.
Many thanks.
This link may help.
Printing Multiple Worksheets on a Single Page
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
It works! Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks