Scarecrowed
New Member
- Joined
- Jan 18, 2011
- Messages
- 8
Hi all,
I already have a macro for printing 2 sheets 16 times in A3 but I'd like to print those two sheets on only one page recto/verso.
Here is my code:
Thanks for your help.
I already have a macro for printing 2 sheets 16 times in A3 but I'd like to print those two sheets on only one page recto/verso.
Here is my code:
Sheets(Array("XX- YY", "WW")). _
Select
Sheets("XX - YY").Activate
ExecuteExcel4Macro "PRINT(1,,,16,,,,,,,,2,,,TRUE,,FALSE)" 'ExecuteExcel4Macro "PRINT(1,,,16,,,,,,,,2,,,TRUE,,FALSE)"
Sheets("Introduction").Select
Range("A28").Select
Application.ScreenUpdating = True
Thanks for your help.