Print both Portrait and Landscape

[Shazz]

Good Afternoon,

I want to format a document in excel where Page 1 prints as Landscape and Page two in the same tab prints as Portrait, can anyone tell me if this is possible and if so how?

Shazz
x

 

[Deepak]

Hi,

This is possible with VBA!!

Sub print_ws()
Dim i As Integer
With Sheet2
    For i = 1 To .PageSetup.Pages.Count
        .PageSetup.Orientation = (i Mod 2) + 1
        .PrintOut i, i, 1
    Next
End With
End Sub

 

[Shazz]

So will this code print sheet 1 as landscape and sheet 2 as Portrait?

Where do i put the code?

Shazz
x

 

[Deepak]

Hi,

What i got is to print the page in landscape /Portrait a sheet... as said in #1 but #3 you asked to print sheet1/sheet2 in that way..

First clear your requirement!

 

[Shazz]

Sorry, I meant Tab1 and Tab 2.

Shazz
x

 

[bobhc]

Where do i put the code?

Take a guess whats at the top of the VBA/Macro section of the forum


http://chandoo.org/forum/threads/help-where-do-i-put-the-code.12106/


Why try to reinvent the wheel, look and you shall find.

 

[Shazz]

That's a bit rude, I am very new to Excel and still finding my feet.

 

[Deepak]

Sorry, I meant Tab1 and Tab 2.

Shazz
x

Are u looking to print sheets in that way..

 

[Deepak]

Y

That's a bit rude, I am very new to Excel and still finding my feet.

Its not rude.
Mr bob is one of the senior member here & what he advised: if followed the same in a nice gesture then it will take strength to stand ur feet as well.