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

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

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

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" <(E-Mail Removed)> wrote in message
news72ED0E0-F9A5-444C-BED5-(E-Mail Removed)...
> 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