Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I change column width in the middle of an Excel sheet? | Excel Discussion (Misc queries) | |||
Worksheet has large page numbers in middle of sheet | New Users to Excel | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
Marcro recroding/ stop Ikon not appearing in middle of excel sheet | Excel Discussion (Misc queries) | |||
page number middle of sheet | Excel Programming |