| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Page Orientation in Excel 2007 | Excel Discussion (Misc queries) | |||
| Pagesetup.Orientation need VBA routine to "Best Guess" Orientation | Excel Discussion (Misc queries) | |||
| Changing page orientation in middle of spreadsheet | Excel Discussion (Misc queries) | |||
| recalculate page breaks after setting Zoom in pagesetup | Excel Discussion (Misc queries) | |||
| PageSetup.LeftFooter only on last Page | Excel Worksheet Functions | |||
Linear Mode
