1. M

    Set Paper Size

    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]
  2. kelly mort

    Set papersize with vba

    <code class="lang-vb" style="line-height: 19px; -webkit-font-smoothing: auto; font-family: monospace, monospace; font-size: 0.875rem; border-radius: 2px; display: block; padding: 0px; border: 0px; direction: ltr; box-sizing: inherit;">Worksheets("Sheet1").PageSetup.PaperSize = xlPaperQuarto I...
  3. S

    FitToPagesWide Integer Code & PaperSize Selection

    I am doing up a Print Macro for a worksheet. I would like it to be dynamic such that I could select for certain Tabs in the workbook to be printed as Zoom or Fit to Pages I have no problem with Zoom but I do have problem writing the codes for FitToPagesWide. I know these two are mutually...

Some videos you may like

This Week's Hot Topics