paper size

Hi guys, I have the VBA code below to print the active worksheet to PDF in the Downloads folder. It prints to A4 sheet size on my computer BUT on my colleagues computer it prints it to Letter paper size. We want it to always print to A4 paper size, regardless of what computer it's used on or...

Hi, I have an Excel worksheet which is sent to several stakeholders. Some stakeholders want to print out the spreadsheet but want to be able to print it out as A3 automatically. In other words make the spreadsheet i send out as A3 printer friendly. The issue is my PC does not have a Printer...

Hi I have seen a similar threat on here posted in 2009 but unfortunately it doesnt quite answer the issue I am having. I have done a userform which allows the user to select printing to each section(All, A, B or C) of the report to either paper size A3 or A4 looking something like below -...

I am sorry to bother the forum with such a question but this is getting old. I have my paper size setup to a 11x17 and when I go to file and then print the paper size always says CUSTOM PAPER SIZE and i have to go in and change it. I no its a small issue but Im ready to pull my hair out.

The paper size can be obtained from PageSetup.PaperSize and according the the help file it reports a value according to the XlPaperSize Enumeration. It seems that XlPaperSize is incomplete because it is possible to set paper sizes that is not mentioned in XlPaperSize e.g. For the Adobe PDF...