Custom defined paper size

[jbierman]

If i want to change the paper size on a worksheet to A4, I use

.PageSetup.PaperSize = xlPaperA4

How do i change it to a custom defined paper size?

.PageSetup.PaperSize = xlPaperNew

This doesn't work.

 

[MARK858]

Hopefully this link will explain why you are having this issue but someone might have found a workaround but I haven't seen one yet

http://excelribbon.tips.net/T009390_Defining_a_Custom_Paper_Size.html

 

[jbierman]

Thanks for the quick response. I will try something else.