Hello,
I've been scouring the internet and tried multipe (I'd say more than 6 or 7 by now) different macros to do this without success.

I'm trying to build a Macro (that I can put inside a different, bigger Macro), that will set a thick outer border for the row and column of the selected cell. This will only be to make visual tracking easier, so when I select a different cell, I'd like the thick outer border to be removed form the old cell, and placed in the new cell.

I've seen lots of ways this can be done with color highlights, but the problem I have is that the worksheet I'm using relies heavily on highlighting different objects, and the macros that I've tried modify, remove and reset the colors I have pre-formatted (or need to add) into that sheet.

Please be a little more detailed than usual, I've been struggling with this, but maybe there's some simple step I'm missing.

I'm using Excel 2007.

Thanks in advance,

Chad