Results 1 to 3 of 3

Code fore Sending Multiple Reports to PrintPreview Window

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2008
    Location
    New Jersey
    Posts
    8

    Code fore Sending Multiple Reports to PrintPreview Window

    I have 10 reports (each in a sheet), and a user box with 10 checkboxes. User checks any combination of the 10 reports and then clicks on "Print Selected Reports". I need help writing a macro that would take every report checked and send them together to Print Preview.

    I tried using the If Then Else structure, but I think it's pretty much impossible to account for every combination of reports. Basically the macro must take all of the checked reports and add them to an array where it looks like this:

    Sheets(Array("APOD 1-Year", "Income Statement", "Lender Summary")).Select
    ActiveWindow.SelectedSheets.PrintPreview
    But i need help figuring out how to add each report to the array. Or maybe there is a better way? Any help is really appreciated!
    Last edited by DaniilK; 09-26-2009 at 08:28 PM.

Thread Information

Users Browsing this Thread

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

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