How to Use Macro To Fit Print Area Into Just One Page | Excel VBA Tutorial

preview_player
Показать описание
Your donation will support me to continue to make more tutorial videos!

In this tutorial I am going to share a simple VBA script that I use frequently to automatically fit the print area into just one page with Excel VBA.

Visit my website
Рекомендации по теме
Комментарии
Автор

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?

chrw
Автор

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

bpclubsport