Column/Row Indicator

[Guest]

I've recently wrote a procedure that draws borders around the entire column
and entire row associated with the selected cell so that it's easier to
locate the cell within the worksheet. Upon changing your selection, the
borders around the entire row/column associated with the original cell are
erased and new ones are drawn around the entire row/column around the new
cell selection. I've been trying to brainstorm of ways to accomplish this
without completely erasing whatever borders that may have previously existed
within the worksheet. PasteSpecial for formats doesn't seem particularly
viable, and I've yet to see an example that doesn't erase the original
formatting. Any suggestions are appreciated.

 

[Guest]

You can downoald this and save yourself a bunch of trouble...

http://www.cpearson.com/excel/RowLiner.htm

 

[Guest]

Thanks.
Apparently their way of working around it was to draw in actual lines.

 

[Bob Phillips]

Do it with conditional formatting instead of overlaid formatting.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)