Temporary highlight row of active cell

[hutch@edge.net]

Greetings gurus,

When looking at a spreadsheet with many columns, it would be nice of the row of the cell I have selected would remain highlighted in yellow, so that as I scroll across rows it's easy to view the data associated with the selected cell. Of course, if I select antoher cell, I would want the highlighting to change to THAT row. I'm guessing this would have to be in a this.workbook change event.

I tried a search on this forum, with no luck. Does anyone know of a simple way to do this?

Thanks in advance.

[mikerickson]

Something like this might work. It uses the SelctionChange event rather than the Change event.

Please Login or Register  to view this content.

[Cutter]

Since I think you wanted to highlight ROWS and not COLUMNS just change Columns references to Rows in the code that Mikerickson gave you.

....and turn Screen Updating back on before End Sub

[hutch@edge.net]

How cool is that?!? Thanks to Mike for the code, and to Cutter for the correction. Works perfectly. I simply added the following code in the Worksheet module:

Please Login or Register  to view this content.

Thanks a million, guys. This thread is Solved!

[svazquez27]

hi guys,
I want to try the above. How do i input this code to excel?

[Methodician]

Just FYI - I developed this alternative to help keep track of the row of my selected cell without interfering with ANY formatting. (adapt to your own needs)

THIS MUST GO INTO THE WORKSHEET CODE OBJECT - NOT A MODULE. Ask for clarification if needed.

Please Login or Register  to view this content.

Feel free to spread the code love. A mention of Methodician would be appreciated.

[Methodician]

Also - LOOK!

http://www.tushar-mehta.com/publish_...d%20cell.shtml

This might be the best method in some cases but I found it created more problems in my formatting-heavy sheet than the above code block. It did fix the flickering issue though. Not worth it in my case.

[samninie]

hi...everyone...
i'm new here...
i need help to Temporary highlight of active cell in Table...can anyone help me solve this

[Methodician]

You need to be more specific. What in the above is not working for you? What exactly are you trying to do? Can we see your malfunctioning code?

[arlu1201]

samninie,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

[greebo89]

THIS MUST GO INTO THE WORKSHEET CODE OBJECT - NOT A MODULE. Ask for clarification if needed.

[CODE]Public CurrentRow As Range 'THIS MUST BE PUBLIC AND MUST BE OUTSIDE THE SUB OR THE DATA WILL BE LOST AND FORMATTING ARTIFACTS WILL BE A MESS

Hi i am struggling with this, very new to any sort of coding in excel, "not a module"? and "must be public" are confusing me, tried straight copying and pasting in the the code box for sheet 1 but it doesnt appear to do anything? using excel 2013.