Changing page orientation with pagesetup
I am trying to change the orientation of all of the pages
in a work book to landscape using Pagesetup.Orientation ...but am not sure how to list the method or what to follow "orientation Any Ideas |
Changing page orientation with pagesetup
Hi
the easiest way to get this information is to record a macro while doing this manually :-) -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... I am trying to change the orientation of all of the pages in a work book to landscape using Pagesetup.Orientation ...but am not sure how to list the method or what to follow "orientation Any Ideas |
Changing page orientation with pagesetup
To add to Frank's reply, the next thing to do is to delete all the recorded
lines but the ones you need. Pagesetup is very slow, and running the approximately 40 statements is a noticable delay. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Frank Kabel" wrote in message ... Hi the easiest way to get this information is to record a macro while doing this manually :-) -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... I am trying to change the orientation of all of the pages in a work book to landscape using Pagesetup.Orientation ...but am not sure how to list the method or what to follow "orientation Any Ideas |
All times are GMT +1. The time now is 09:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com