If you want to setup the page to fit within one page for printing, you have to use the code below. It is important to add the .zoom=false line to switch off the zoom. Without it, the macro will not work.
Share this page:
Would you prefer to share this page with others by linking to it?
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft