LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
mrice
 
Posts: n/a
Default Printing two tabs of the same worksheet to one double-sided page


Jennifer

Double sided printing is most likely to a setting on your printer.

You can go through all your sheets by wrapping your macro within a for
-next loop.


For Each Sheet in ActiveWorkbook
...
Your code
....
Next Sheet

Martin

http://homepage.ntlworld.com/martin.rice1/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532721

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing worksheet not the same across the board Rose Setting up and Configuration of Excel 1 March 21st 06 11:02 PM
Worksheet Tabs TheJaxSun Excel Discussion (Misc queries) 5 December 4th 05 03:37 AM
How to show query parameters on an Excel page header or worksheet? Paul Jones Excel Discussion (Misc queries) 0 September 7th 05 05:18 PM
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 10:12 PM


All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"