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
|