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