Printing Macro Problem - Setting Default printer

Hi everyone
I am receiving an error: Run tim error 1004 - Application Defined or object define error.
So im guessing it doesnt like that i've Dimensioned Orientation and PaperSize as Strings?
What should they be dimensioned as?

Please Login or Register  to view this content.

I can't really see what relevance the question title is, you don't set the default Printer.

You can't declare variables that are used by Excel, use

Please Login or Register  to view this content.

You also don't need to Select the Sheet, nor Activate it