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:
The array now looks like this:![]()
Please Login or Register to view this content.
.![]()
Please Login or Register to view this content.
.
.
Now how do I select all of those ranges so that the following print statment works?
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?![]()
Please Login or Register to view this content.
Thanks.
Bookmarks