Reset a volatile print area

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.

Please Login or Register  to view this content.

or maybe

Please Login or Register  to view this content.

Have a quick read here.
http://stackoverflow.com/questions/1...cel-vba-macros

http://www.businessprogrammer.com/po...-using-select/

http://dailydoseofexcel.com/archives...-and-activate/

Originally Posted by protonLeah

You should post a workbook; however you might try:

Please Login or Register  to view this content.

I truly thought I should (post a workbook) but it would have required a full rebuild as the data in the workbook is confidential... no, very confidential.

That stated, I used your suggestion and it worked as you thought it might. jolivanes suggestion worked as well. I am a power Excel user when it comes to formulas and other "internal" Excel features. However, I have only dabbled in VBA. The myriad of coding options is often daunting to a VBA greenhorn like me. The help offered quickly and succinctly by the forum regulars is not only immeasurably helpful, but also refreshing. Thank you all so much.

Your suggestion worked well. I also thank you for the reading material. My dabblings in VBA clearly pointed to the abhorrence of .Select but the readings confirmed it and gave me viable options. Thanks so much.