Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Correction: .zoom = false makes a difference. I didn't notice I'd put
..zoom = false statement twice. Also .LeftHeader = Ref.LeftHeader and .CenterHeader = Ref.CenterHeader (I noticed I could use &A in the reference sheet instead so ..centerheader = ref.centerheader is much better.... ) With Sheets(SelSh) With .PageSetup .Zoom = False .PrintArea = Ref.PrintArea .LeftHeader = Ref.LeftHeader .CenterHeader = Ref.CenterHeader and please exclude the last line .zoom = False before End with of ..pagesetup. BTW, setting .FitToPagesTall = ref.FitToPagesTall .FitToPagesWide = ref.FitToPagesWide does not result in correct pagebreaks in "other sheets". Even if I set say, 64% in zoom option in the reference sheet hence not selecting fittopages options, excel assigns 1 to both ref.FitToPagesTall and ref.FitToPagesWide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying data from several sheets to a front sheet | Excel Worksheet Functions | |||
copying text on sheet 1 to corresponding cells on sheets 2 to 5 | New Users to Excel | |||
Copying Data from Multiple Sheets to One sheet | Excel Worksheet Functions | |||
Copying only report sheets | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions |