+ Reply to Thread
Results 1 to 8 of 8

Printing multiple tabs/sheets using VBA

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    Naples, FL
    MS-Off Ver
    Excel 2003
    Posts
    5

    Printing multiple tabs/sheets using VBA

    Hello,
    New to the forum and a newbie when it comes to VBA.
    I have been looking at this forum for help and it has been great.
    I have been able to get to solve my "auto numbering up " upon printing but I need your help with being able to print multiple sheets when I print.
    I have included the spreadsheet and what does not work is this "Sheets(Array("traveler", "Inspection")).Select". It only prints the traveler.
    I am trying to print the Traveler and Inspection sheet at the same time.

    Thanks in advance for your help.
    Attached Files Attached Files

  2. #2
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Printing multiple tabs/sheets using VBA

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-03-2014
    Location
    Naples, FL
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Printing multiple tabs/sheets using VBA

    Thanks. That was quick.
    That worked as intended but now my issue is that the incrementing of the printing is not correct. To make myself clear. Let's say I want to print 2 travelers and the starting number is 2015. The first traveler will print 2015 but the second one will print 2017 because it printed an inspection sheet. I would need the second traveler to be 2016. Can you help?

  4. #4
    Registered User
    Join Date
    02-03-2014
    Location
    Naples, FL
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Printing multiple tabs/sheets using VBA

    Thanks. That was quick.
    That worked as intended but now my issue is that the incrementing of the printing is not correct. To make myself clear. Let's say I want to print 2 travelers and the starting number is 2015. The first traveler will print 2015 but the second one will print 2017 because it printed an inspection sheet in between. I would need the second traveler to be 2016. Can you help?
    Last edited by azimuthtec; 02-21-2014 at 04:53 PM.

  5. #5
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Printing multiple tabs/sheets using VBA

    try this
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    02-03-2014
    Location
    Naples, FL
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Printing multiple tabs/sheets using VBA

    Nope. Let's say my starting number on excel is 10046, it prints traveler 10047, inspection sheet, traveler 10049 and inspection sheet. Number on excel is now 10050 (that is fine).
    What I need is traveler 10046 and traveler 10047. Number on excel should be 10048.

  7. #7
    Forum Contributor thameem127's Avatar
    Join Date
    04-06-2012
    Location
    Jeddah,Saudi Arabia
    MS-Off Ver
    Excel 2003,Excel 2007
    Posts
    321

    Re: Printing multiple tabs/sheets using VBA

    Check this attached file TRAVELER TEMPLATE.xlsm

  8. #8
    Registered User
    Join Date
    02-03-2014
    Location
    Naples, FL
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Printing multiple tabs/sheets using VBA

    Thanks for your help but when I use your new file, it only prints one traveler and one inspection sheet even when I say I want 2 or 3 copies. The numbers do go up but only one print. Before it did print all the copies I needed but it would increment by 1 for the inspection sheet and I do not want that. I need the number to go up by one for every traveler printed not every inspection sheet. I hope I make myself clear.
    Thanks for continuing to help me

+ 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. vlookup over multiple tabs/sheets
    By balasus in forum Excel General
    Replies: 4
    Last Post: 02-21-2011, 04:52 AM
  2. Problem Printing Multiple tabs
    By bbddvv in forum Excel General
    Replies: 2
    Last Post: 07-11-2006, 03:00 PM
  3. Multiple Files & Tabs Printing Options
    By gallan in forum Excel General
    Replies: 0
    Last Post: 05-01-2006, 09:35 AM
  4. [SOLVED] printing multiple sheet tabs to image file
    By 0492-Examiner in forum Excel General
    Replies: 0
    Last Post: 10-19-2005, 06:05 PM
  5. Printing multiple tabs to pdf file
    By phippsto in forum Excel General
    Replies: 0
    Last Post: 02-22-2005, 09:56 AM

Tags for this Thread

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