Re: How to highlight row and column of the selected cell

[Max]

Try Chip Pearson's:
http://www.cpearson.com/excel/RowLiner.htm

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Row_Column_Highlight" <Row_Column...@discussions.microsoft.com>
wrote in message news:79F55982-331D-4D41...@microsoft.com...
> Dear All
>
> Whatever cell I select, I want to hightlight the relative row and column
of
> that cell, how?
>
> Thanks in advance.
>

[Ken Wright]

This will do what you want, but as with any event driven VBA solution of
this sort you will lose any undo functionality whilst it is in operation

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------