+ Reply to Thread
Results 1 to 3 of 3

Print two print areas on one via a macro, for a loop

  1. #1
    Registered User
    Join Date
    10-18-2018
    Location
    London
    MS-Off Ver
    2016
    Posts
    4

    Print two print areas on one via a macro, for a loop

    Hi All,

    Pretty straightforward question, but a solution is evading my skill/know how (and patience) - I've tried manipulating it manually but the printing doesn't come out as expected, and I've googled but nothing I've been able to manipulate in the module is working.

    On my worksheet I have two print areas. I have a button that will automatically save these to an A4 PDF within the same file (so a two-page PDF) however, for printing I would like them printed side-by-side on an A3 sheet as a front and back type wrap around.

    The simple solution would be to print from the PDF...but the worksheet contains a cycle which allows me to save/look at data for 100s of people - so when saving to PDF, the identified people will each have a pdf created meaning printing from PDF would be tiresome.

    Basics of what I want:
    Two print areas printed on one side of A3 as two pages of A4 side-by-side (the final 'product' is a landscape A3, designed from two portrait A4 pages).

    Any help would be greatly appreciated!

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Print two print areas on one via a macro, for a loop

    Have a macro copy the two print areas to a temporary worksheet so they are side-by-side and print the entire sheet to A3 landscape.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    10-18-2018
    Location
    London
    MS-Off Ver
    2016
    Posts
    4

    Re: Print two print areas on one via a macro, for a loop

    Quote Originally Posted by AlphaFrog View Post
    Have a macro copy the two print areas to a temporary worksheet so they are side-by-side and print the entire sheet to A3 landscape.
    Thanks.

    That did cross my mind, but that exceeded my own capabilities - my experience of macros and vba is copying and pasting what I can find and somehow manipulating them to suit.

    What would the code look like to do as you suggest, and would it work automatically for a loop so I only have to click the button once and it will print off all sheets on A3, cycling through each person I need it to?

    For ease, I'll pretend the sheet containing the print areas is named 'Feedback' and the two print areas are $A$1:$E$10 and $G$1:$T$12; I have a loop using i from StartRow to EndRow.

+ 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. Want to print only two print areas in one sheet(combined)
    By jayarajmarydasan in forum Excel General
    Replies: 1
    Last Post: 05-04-2016, 04:24 AM
  2. Macro to print multiple print areas on one page.
    By morangeman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2015, 12:13 PM
  3. Create buttons to print defined print areas
    By nwpassage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2015, 11:17 PM
  4. Print selected Print Areas to a PDF
    By Santanae in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2013, 10:42 AM
  5. VBA code to print several print areas in one worksheet
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2010, 03:24 PM
  6. How to print multiple print areas on the same page.
    By Dalilah in forum Excel General
    Replies: 5
    Last Post: 08-27-2008, 09:05 AM
  7. [SOLVED] printing multiple print areas with a print dialog box
    By LHaro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2005, 05:05 PM

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