In advance, thanks so much for your time and attention.
I am using a pivot table to query a large spreadsheet for select data. The pivot table is always four columns wide but can vary widely in length. I have recorded a macro to select the appropriate area to print, format the selected area however, I am not able to get the macro to "re-define" the print area after the pivot table is refreshed and the appropriate area is selected. The following code does all the above stated tasks nicely but the ActiveSheet.PageSetup.PrintArea = "$B$10:$E$19" line fails me. Clearly I need help getting around the absolute range reference.
Thanks again.
Bookmarks