pagesetup

  1. V

    How do I use the .pagesetup properly?

    I am trying to use different page setups but I get object errors. What is the proper way to use the page setup arguments? Sub Print_DB() Dim db As Worksheet With db .PageSetup.FitToPagesWide .PageSetup.PaperSize = xlPaperLetter .PageSetup.Orientation...
  2. Johnny Thunder

    VBA Help - Working with Pagesetup Function - Issues with Setting Header Font Size

    Hi gang, I am working with some code that sets print formats for a summary page and I am encountering the strangest thing. Issue Whenever I run the code on files that contain filenames that have numbers in them (example: 300 Racks) the .PageSetup.CenterHeader code that I have gets...
  3. 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...
  4. A

    Page Numbers Sequential (but then repeating numbers?!)

    Hi there, I have 10 pages in my workbook - made up of 5 tabs each with 2 pages When I select all tabs and go to print, they sequentially number 1 - 10 (I have set up a Footer with "Page &[Page]" to do this) I want the first page to be number 7 - so change the First Page Number from 'Auto' to...
  5. D

    Setting PageSetup using VBA

    I have a workbook currently with 1 worksheet in - it has a macro that creates a series of new sheets and what I would like is to have the page set up copied from the sheet currently called sheet1 to all the new sheets (could be any number up to 20 created depending on what data is on sheet 1) I...
  6. L

    Distinct Print Layout for each page in a Worksheet

    Not sure if this is possible, but figured I'd check here just in case. I have a sheet that has 3 different pages on the same tab, and I'd like to be able to set the print layout/setup of each page in the sheet separately. More specifically, I want to print the first two pages at PageSetup.Zoom...
  7. S

    Print Options via Macro

    I currently have a workbook template that is setup with two tabs and is used to create a file for each day of the week. One tab is oriented in portrait (fit to page), the other is oriented in landscape (fit to page). There is a macro to print the workbook. The problem I have is that it uses...
  8. M

    "New line" in footer with pagesetupfooter

    Hello, please I have a problem with adding more lines into footer using pagesetupfooter. Does onyone know what special character can I use for new line in footer text? ActiveSheet.PageSetup.LeftFooter='Text in First line'+'\N '+'Text In Second Line' But \N does not work. Any Ideas? Thanks a...

Watch MrExcel Video

First Look: Excel VBA Killer - TypeScript Debuts in Excel - Ep # 2322

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top