How to highlight row and column of the selected cell

[Row_Column_Highlight]

Dear All

Whatever cell I select, I want to hightlight the relative row and column of
that cell, how?

Thanks in advance.

[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" <[email protected]>
wrote in message news:[email protected]...
> 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 :-)
----------------------------------------------------------------------------

"Row_Column_Highlight" <[email protected]>
wrote in message news:[email protected]...
> Dear All
>
> Whatever cell I select, I want to hightlight the relative row and column
of
> that cell, how?
>
> Thanks in advance.
>