Dear All

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

Thanks in advance.

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Row_Column_Highlight"
wrote in message ...
Dear All

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

Thanks in advance.

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

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

Thanks in advance.