+ Reply to Thread
Results 1 to 4 of 4

VBA to print worksheet array

  1. #1
    Forum Contributor Pierce Quality's Avatar
    Join Date
    07-29-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    221

    VBA to print worksheet array

    Hi All,
    I was wondering if anyone could help with a subscript 9 error that Ive been getting when I run this macro.
    It has worked in the past, but when I tried to test it today I keep getting errors on the array portion.
    Any help would be greatly appreciated, thanks!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to print worksheet array

    Error 9 means 1 or more sheet names do not exist on sheet array collection

  3. #3
    Forum Contributor Pierce Quality's Avatar
    Join Date
    07-29-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: VBA to print worksheet array

    Quote Originally Posted by AB33 View Post
    Error 9 means 1 or more sheet names do not exist on sheet array collection
    Thanks AB33, looking into it now.

  4. #4
    Forum Contributor Pierce Quality's Avatar
    Join Date
    07-29-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: VBA to print worksheet array

    Looks like I had a space before one of my sheet names, works great now, thanks!

+ 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] Populate one array from another array and print new array as a range
    By Kaden265 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2014, 07:52 AM
  2. Replies: 0
    Last Post: 02-04-2013, 02:28 PM
  3. [SOLVED] Print array code for a series of pages that will also determine print area required?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2012, 11:46 PM
  4. [SOLVED] Macro to print the current worksheet WITHOUT having Print Preview
    By terrydennis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2012, 11:00 AM
  5. [SOLVED] Print to worksheet and Jagged Array
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2012, 07:50 PM

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