Column/Row Indicator
 

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.

--------
Thanks,
Anony

Column/Row Indicator
 

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

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

Jim Thomlinson


"Anony" wrote:

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.

--------
Thanks,
Anony

Column/Row Indicator
 

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

--------
Cheers,
Anony


"Jim Thomlinson" wrote:

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

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

Jim Thomlinson


"Anony" wrote:

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.

--------
Thanks,
Anony

Column/Row Indicator
 

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)

"Anony" wrote in message
...
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.

--------
Thanks,
Anony