1. 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...
  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. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...

Some videos you may like

This Week's Hot Topics