ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why Doesn't This Work? (Page Setup) (https://www.excelbanter.com/excel-programming/436260-why-doesnt-work-page-setup.html)

EricG

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


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com