Depends on your version of XL. In XL03/04, xlLandscape is a defined
constant with the value of 2.


In article ,
wrote:

I found the reason the macro below didn't work.

In XL4 a landscape Orientation should be "2" not "xlLandscape". When I set
Orientation:="2" everything worked.