Page Setup. Paper Size Question

[Kavy]

Hello, using an excel vb user form
I would like to set my paper size to 11 x17 on the fly

This seems to work:

wsf.PageSetup.PaperSize = xlPaperTabloid

And according to the help file, this should also give me 11 x 17 but it gives me an error anyone know why?

wsf.PageSetup.PaperSize = xlPaper11x17

Thanks!

 

[Norie]

And the error is?

 

[Kavy]

Hmm good point, hows it going norie, haven't been on in a while..

"Unable to set the Paper Size Property of the Page setup class"

is the error.

Whats the differance in the two formats?
Thanks as always!

 

[Kavy]

just to refresh, anyone know?