Results 1 to 1 of 1

Printing an array of ranges

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2007
    Posts
    1

    Printing an array of ranges

    I've tried dozens of ways to try to get print ranges on multiple sheets to print to a single pdf file. What I have finally done is created an array in my macro to grab the print areas from several pages:

    prntarray = Array(Sheet12.Range("Print_Area").Name, Sheet23.Range("Print_Area").Name,...)
    The array now looks like this:
    prntarray(0) "=B!$A$6:$L$23"
    prntarray(1) "=A!$B$6:$AR$177"
    .
    .
    .

    Now how do I select all of those ranges so that the following print statment works?

    Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:=
            PrintTo & ".pdf", Quality:=xlQualityMinimum, _
            IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
            True
    I'm wondering if I need to concatenate all of the print ranges into one big print range first and if so, how would I do that?

    Thanks.
    Last edited by LAMoore; 08-28-2012 at 10:36 AM. Reason: typo

Thread Information

Users Browsing this Thread

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

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