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

.....the rows that were merged and centered. I hope this makes sense

Merging cells seldom makes sense!

How many rows should your last entry "MNO CO" have?

Try this

Because I can't determine where your sheet ends, put some text in Column A in the last row + 1 that you need merged anything will do e.g. "Stop"

Then run this macro

Please Login or Register  to view this content.

If you don't define this last row, (effectively the next set to merge), the code will not format your last data group.

Hope this helps.