How can I set the papersize in VBA based on the value in a named range.
If the user has chosen US I want the papersize to be letter, else A4.
I have tried the following without success. PrintpaperSize is my named range
ActiveSheet.PageSetup.PaperSize = [PrintPaperSize]