LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Report: Copying pagebreaks of a reference sheet to other sheets

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
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
Copying data from several sheets to a front sheet Marie Green Excel Worksheet Functions 1 April 9th 09 11:51 AM
copying text on sheet 1 to corresponding cells on sheets 2 to 5 Lisa New Users to Excel 5 October 1st 08 06:01 AM
Copying Data from Multiple Sheets to One sheet MAB Excel Worksheet Functions 1 January 15th 08 08:28 PM
Copying only report sheets jesmin Excel Discussion (Misc queries) 0 January 16th 06 06:12 PM
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? Daniel Excel Worksheet Functions 1 July 6th 05 09:57 PM


All times are GMT +1. The time now is 05:59 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"