+ Reply to Thread
Results 1 to 5 of 5

print sheets BY array values

  1. 10-23-2013, 11:45 PM #1
    petix
    petix is offline
    Registered User
    Join Date
    10-23-2013
    Location
    Prague
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question print sheets BY array values

    Hi experts, I'm new to VBA as well as to this forum.

    I have a code which, based on the checkboxes checked, fills the array SNarray with names of worksheets.
    Then I need to use this list of worksheets for printing them out - I need to do it at one printing job....not sheet by sheet. And excel is giving me back the famous "error no. 9 - Subscript out of range"
    Please Login or Register  to view this content.

    Any idea how to address all the array's values and pass them all together as an argumet?

    thanks a lot
    Last edited by Leith Ross; 10-24-2013 at 12:02 AM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  2. 10-24-2013, 01:06 AM #2
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: print sheets BY array values

    Like this?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-24-2013, 02:15 AM #3
    petix
    petix is offline
    Registered User
    Join Date
    10-23-2013
    Location
    Prague
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: print sheets BY array values

    Hi jolivanes...this is not what I'm trying to achieve.
    I need to have all the values printed into one file - this is what I meant by "at one printing job". I didn't expresed myself correctly.

    Your solution will start as many printing jobs as is the number of values in the array...I need to start just one printing and have all the values from array considered within this job.
    Reply With QuoteRegister To Reply
  4. 10-25-2013, 04:46 PM #4
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: print sheets BY array values

    AFAIK you'll need to copy everything into one sheet (temp sheet?) and print that.
    I am not aware of a way to print different sheets into one print job.
    Maybe someone else knows how to do that.
    Reply With QuoteRegister To Reply
  5. 10-29-2013, 06:51 AM #5
    petix
    petix is offline
    Registered User
    Join Date
    10-23-2013
    Location
    Prague
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: print sheets BY array values

    I solved it by myself...I had to change the commands within FOR statement but works perfect
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to loop through sheets and print them out using an array
    By Masact in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2009, 04:00 PM
  2. [SOLVED] Print Array for hidden sheets using VBA
    By Ant in forum Excel General
    Replies: 1
    Last Post: 03-27-2006, 06:24 AM
  3. Print Array for hidden sheets using VBA
    By Ant in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2006, 04:30 AM
  4. Print Array for hidden sheets using VBA
    By Ant in forum Excel General
    Replies: 0
    Last Post: 03-22-2006, 12:35 PM
  5. [SOLVED] Creating an array of sheets to print
    By Luc Dansereau in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2005, 01: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1