highlight active row

[hakeae]

This is so simple that I must be really dense but I can't figure our how to do this -

I want the whole row containing the active cell to be highlighted so I can see what I am working on, all the way across. Can someone tell me how to do this please?

 

[jeffreyweir]

Damn...I've tried to reply to this thread three times, but my reply never shows up.

Check out thse links:

http://dailydoseofexcel.com/archives/2012/03/21/highlight-row-and-column-of-active-cell/

http://msdn.microsoft.com/en-us/library/office/ff820716.aspx


Edit: Ahh, I see it's working now. Problem was likely caused by me pasting links with no tabs, which probably went to the moderation queue.

 

[NARAYANK991]

Hi ,


One more link :


http://chandoo.org/wp/2012/07/11/highlight-row-column-of-selected-cell-using-vba/


Narayan

 

[hakeae]

Thanks for the replies. It's great, I love it!

Ignorance is a sad thing - I always thought Excel was just a simple glorified table, calculator & sorter but VBA is magic! Have to do a course now!