Forum Discussion
Printing different Print area sizes on different pages.
You can record one doing these steps:
- Set up first area the way you like and print it
- Repeat for second one
- Stop recorder
This macro should now give you two prints the way you selected during recording.
Hello Jan,
Thank you for the response. I am aware that, yes, it would be a better solution to have it on different sheets, but its very curious to me that someone else was able to do this.The discussion is about whether it is possible to print multiple pages in different sizes. In case it wasn't clear attached are some reference pictures.
In the pdf copies, you can see that they are printed perfectly. It's just hard to think they did this all manually and made their lives more difficult by setting each print area and exporting one page at a time for 15-20 documents with 2-10 pages instead of just having it on 2 sheets or making a macro for each of these pages, which is highly unlikely since the excel they had provided did not have any macros. My guess is that there must be some method to their madness.- I suspect the second table is actually a (linked) picture of a table located somewhere else. That was the next thing I was going to suggest. Google for excel camera tool and you'll find plenty instructions
Very neat solution! I still don't think this is how they accomplished it but I'll give it a shot with this.
Thanks!
