Need macro to add thick box border to certain cells - THANKS FOR THE HELP!!!

Hi All,

I want to thank you in advance for your help.

I have attached a spreadsheet of what I am needing the macro to do. Essentially, whenever the macro searches column A and finds a new value, I need it to merge and center all rows in column A using the previous value. Then I need the macro to put a thick box border around the outside rows for the rows that were merged and centered. I hope this makes sense.

I'm using Excel 2010 if that makes a difference in macro.

Thanks!
Jeff