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.