Changing page orientation with pagesetup

G

Guest

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
 
F

Frank Kabel

Hi
the easiest way to get this information is to record a macro while
doing this manually :)
 
B

Bob Flanagan

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
 
Top