+ Reply to Thread
Results 1 to 2 of 2

Print blank page between page 1 and 2 on macro printing

  1. #1
    Registered User
    Join Date
    02-07-2015
    Location
    Montréal
    MS-Off Ver
    2010
    Posts
    2

    Print blank page between page 1 and 2 on macro printing

    I have been working on a workbook to help my coworker making paperwork faster. In the workbook I made a print button with an "automaticaly built (recorded) macro" to print 8 spreadsheets at the same time. Everybodies printer is sets to print on 2 sides so we should have 4 sheets of 2 pages but I have page 1 on a sheets then page 2-7 on 2 sides sheets and page 8 by itself. Would you know how to fix this?
    Code is in "module 11"
    Please Login or Register  to view this content.
    09-ATM-Arriel.xlsm09-ATM-Arriel.xlsm
    2015-12-07_10h50_17.png

  2. #2
    Registered User
    Join Date
    02-07-2015
    Location
    Montréal
    MS-Off Ver
    2010
    Posts
    2

    Re: Print blank page between page 1 and 2 on macro printing

    You can also take a look at all codes to see how all my macros are weirdly coded... but it's workking correctly, or almost correctly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Second blank page keeps printing
    By 1LRick in forum Excel General
    Replies: 4
    Last Post: 01-29-2014, 03:37 PM
  2. need a macro to print 2 page of a worksheet onto 1 a4 page
    By echobase77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2014, 06:57 AM
  3. How to have 2 Different Printing Layouts for a 2 page macro print job (paper/PDF)
    By bobby.bobby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2013, 04:06 AM
  4. How to copy format of previous printing-page and apply to the next printing-page?
    By Morrigan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 06:01 PM
  5. Hide Column & Print page Macro printing blank page?!
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2013, 03:59 PM
  6. Macro and not print a blank page?
    By stephenw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2007, 06:36 PM
  7. Printing Issue - Fit to Print 1 Page Wide
    By mdalby in forum Excel General
    Replies: 2
    Last Post: 02-13-2007, 02:07 PM
  8. Replies: 4
    Last Post: 02-17-2006, 08:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1