how do I change page layout in vba

's Computer Specifications

I am trying to find the code to change the page layout from portrait to
landscape without having to rewrite the entire code again.

Nowhere in the coding does it distinctively show the page layout properties.

's Computer Specifications

With Worksheets("Sheet1")
.PageSetup.Orientation = xlLandscape
.PrintOut
End With

Copied directly from VBA help on "landscape"

Gord Dibben MS Excel MVP

On Mon, 18 May 2009 16:05:00 -0700, swanno
<(E-Mail Removed)> wrote:

>I am trying to find the code to change the page layout from portrait to
>landscape without having to rewrite the entire code again.
>
>Nowhere in the coding does it distinctively show the page layout properties.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change page layout after 20 records.	jaworski_m	Microsoft Access Reports	3	11th Jun 2009 09:07 PM
Change the layout of the 1 page/day calendar	=?Utf-8?B?RWR3YXJkOTk=?=	Microsoft Outlook Calendar	1	26th Apr 2006 02:05 PM
word should let me change the page layout of the current page onl.	=?Utf-8?B?U2hpdGl6IEJhbnNhbA==?=	Microsoft Word Document Management	1	17th Feb 2005 06:09 AM
Is there an event for change in page layout?	Max Moor	Microsoft Access Reports	0	1st Dec 2004 03:25 AM
Page layout will not change	=?Utf-8?B?SmFu?=	Microsoft Word Document Management	1	6th Aug 2004 07:38 PM