I need a macro that will select a named pivot table and will format the page setup to fit on one page.

Thanks!!