Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Landscape AND Portrait Orientation in ONE Worksheet
Hi guys
- I have a very large worksheet to print. - All but one page need to print in Portrait. - The page number of the page that needs to print in Landscape is unknown, though it's location can be ascertained by a number of means, such as tagging the start point as a named range. - I have found the following code posted previously by Stephen Bullen (apologies for the previous error in surname): With ActiveSheet .PageSetup.Orientation = xlLandscape .PrintOut From:=1, To:=1 .PageSetup.Orientation = xlPortrait .PrintOut From:=2 End With - This looks close to the mark, except that I need From and To to be dynamic rather than static. Any suggestions appreciated. Thanks in advance Paul Martin Melbourne, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Orientation Landscape but want Page #s to Print Portrait | Excel Discussion (Misc queries) | |||
Print one page landscape and one portrait | Setting up and Configuration of Excel | |||
change default page orientation from portrait to landscape | Excel Discussion (Misc queries) | |||
Portrait/Landscape print issue | Excel Discussion (Misc queries) | |||
Print both Portrait and Landscape - Excel | Excel Discussion (Misc queries) |