Dear Jie Jenn, this is so close to what I need, but sadly not completely. I have several sheets all with exactly the same setup that I need to export with different Printareas. Hence I am looking for a way to apply this Code to all selected sheets not just the active one. I can't get it to work that way. any ideas how to modify the code?
We have a macro to print a page but it prints so tiny. Can you let me know how to make it big? Or fit to a page. Note the macro was already written by someone
It could be you have too much information on your worksheet and you are trying to print them into one page. Maybe cut down few sections to print less stuff or print to multiple pages.
Dear Jie Jenn,
this is so close to what I need, but sadly not completely.
I have several sheets all with exactly the same setup that I need to export with different Printareas. Hence I am looking for a way to apply this Code to all selected sheets not just the active one. I can't get it to work that way.
any ideas how to modify the code?
We have a macro to print a page but it prints so tiny. Can you let me know how to make it big? Or fit to a page. Note the macro was already written by someone
It could be you have too much information on your worksheet and you are trying to print them into one page. Maybe cut down few sections to print less stuff or print to multiple pages.
Jie Jenn thank you I already figured out to do it
Jie Jenn Thank you bro you help me !
Can you share the vba script
I uploaded the script to my github account. Here's the link to the script gist.github.com/DataSolveProblems/e1ca912f43c9d0b3cf82a3ec46ceaa66