Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 220
Default Why Doesn't This Work? (Page Setup)

I have this working the long way (using each separate component of the page
setup object). Why doesn't the code below work? Seems like it should.

Sub Set_Page_Setup(wsh1 as Worksheet, wsh2 as Worksheet)
Set wsh1.PageSetup = wsh2.PageSetup
End Sub

Thanks,

Eric
Reply
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
Page layout - page setup - items disabled Bill D - Hubbard & Co Excel Discussion (Misc queries) 6 February 2nd 10 04:34 PM
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE Randy Excel Worksheet Functions 1 February 8th 07 06:15 PM
Page setup doesn't work hedda1976 Excel Discussion (Misc queries) 2 September 23rd 06 06:01 PM
Excel 2003 - PAGE SETUP - FIT TO WIDTH does not work BisBatt Excel Discussion (Misc queries) 1 February 1st 06 07:00 PM
Is there a way to apply "page setup" defaults to an existing work. Excel default page set up formats Excel Discussion (Misc queries) 2 March 21st 05 10:54 PM


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