I have Excel2000 and I don't know which version of XL it's using. All I know is
that when I changed xlLandscape to "2" the code worked. Thanks again for the
URL

JE McGimpsey wrote:

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.