for some reason xlPaper11x17 does not change my paper size but
xlPaperTabloid does. I tried putting in numerical values and noticed
that some of the numbers do not change the size. For example
xlPaper11x17 gives 17, but if I give the number 17 directly nothing
happens. 11x17 and Tabloid are both listed as options for my printer.

Is one of these options more likely to work then the other? Will one
work on one computer and if I send it to another will it not work
there? How to I ensure that the worksheet will behave the same across
different computers/printers?

Should I set the page size in VBA then check to see if it took (also
in vba) if it did not try the other?

Thanks,
David