How to highlight row and column of the selected cell

[Guest]

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

 

[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