Need help with Macro for Cell Borders

I work for a camp that takes 4,500 kids every summer. I use Excel to keep track of which session each camper is coming and who they want to bunk with. I put borders around the bunkmates to keep them together. Way back when I used an older version of Excel, I created a Macro for putting boxes around pairs of campers. Unfortunately, Excel has changed how some features work and now I'm having trouble. Used to be I could put a box around two cells and a box around two adjacent cells. Then I could move them around with no problem. Now when I move a pair of campers, I lose one of the borders because when there is a border between 2 cells, it acts as a shared border. I need to have it where I can put a border at the bottom of one cell and a border at the top of the cell below it and have each one stay with the cell contents when I move it. I hope that makes sense.

I've researched many times to see if this was possible and I keep seeing stuff about "inside borders". But I haven't been able to figure out if there is a way to create a Macro that will make the borders behave the way I need them too.

Any help I can get would be much appreciated!

I can't recreate your "misfortune"

Please Login or Register  to view this content.

If you now select cells B6 and B7 and pull them down, both ranges still will have a border around the two cells.

Thanks so much for your responses. I have attached a sample document. I use drag and drop. You can see in the second example in the workbook where I lost a border when I moved the second set of names.

I also attached (in a Word doc) the macro that I created. It was done in Excel 2007. (I know that where I used Control-B in 2007, I have to use Control-Shift-B in Excel 2016 because they no longer allow you to use just Control-B since that's normally for bolding things.)

Thanks! I will give that a try when I get to the office on Monday!

Originally Posted by AlphaFrog

I could duplicate your issue.

Try this borders method. It's seemed to work for me. You'll have to recreate the borders for any that already exist.

Please Login or Register  to view this content.

You are my HERO! That is REALLY, REALLY close to what I need! I didn't think to mention it earlier but I also want it to remove any inside borders that might be there when I use the macro. Would that be possible?

Originally Posted by AlphaFrog

Try this...

Please Login or Register  to view this content.

You have no idea how happy you have made me today! I've been fighting with this for 3 years! This will save me SO much time and eliminate errors. Thank SO much!