EXCEL VBA Questions and Answers

How to set the custom paper size in Excel Object through VB?

Activesheet.PageSetup.PaperSize = xlPaperLetter (Similarly xlPaperA4 or xlPaperLegal etc.)