LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default How to print with a gap in the middle of a sheet

I am trying to setup a print button with code to print a range of data
on a 11x17" sheet of paper, portrait layout but to have a break in the
middle of the sheet always so if you fold it in half you will not be
folding over text. I need something like a footer in the middle of the
page. I have 2 seperate parts of the data range. One is for first
shift and the other is for 2nd and 3rd shift. So if you fold the 11x17
sheet in half you get 1st shift data on the front and then the 2nd&3rd
shift info on the other half but with a break in the middle where the
crease is so no text gets folded.
I can make the button and all the code to print but I am trying to
figure out how to create this break in the middle.
Any thoughts or suggestions?

Thanks
Scott
 
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
how do I change column width in the middle of an Excel sheet? Malcolm Excel Discussion (Misc queries) 6 August 13th 09 10:40 AM
Worksheet has large page numbers in middle of sheet knifty New Users to Excel 2 February 19th 07 09:40 PM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 11:29 AM
Marcro recroding/ stop Ikon not appearing in middle of excel sheet vishu Excel Discussion (Misc queries) 3 July 6th 05 11:37 PM
page number middle of sheet seeker53[_2_] Excel Programming 1 June 17th 05 01:02 AM


All times are GMT +1. The time now is 02:27 AM.

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"