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:
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!Please Login or Register to view this content.
Bookmarks