Should Orientation and Papersize not be preceded by a DOT?
.Orientation = xlLandscape, since they refer to the selection defined
just above?
TIP: Setting Print Ranges in VBA is painfully slow on execution. Well
done on keeping yours simple, and not setting borders etc. I racked my
brain a few months ago when I did it the first time!