I have 4 different workbooks with very large worksheets that consist of approx. 100 different Sites with Region Totals. I need to print out the Region Total Sections of each worksheet (Region Totals range from 21 - 36 regions) . My issue is that my worksheets change up on a monthly basis and I have to add new sites to the worksheet. When I insert new sites it drops down the rows and changes where the Region Totals are located within the worksheet.

I added a comment at each Region Total to state "PRINT".
I created a macro to:
Alt F "PRINT" in the comments. (search for the word print in the comments only)
I then select each region and print selection only.

This worked great for me until I had to add new sites and now my macro is thrown off and is printing what is now in the section where the Region Totals originally were when I created my Macro.


Can anyone tell me how to set my Macro to print my Region Totals Sections only even if new sites have been added in and the row #'s have changed?

I thought by adding the comment "PRINT" and having it search for the word Print would do the trick. I was wrong...


Thank you for help.