Highlighting Active Cell in a Table

**Statto** · 10-03-2014, 07:02 PM

I'm trying to find some code that will highlight the column and row of the the active cell. Except, I don't want the whole column and row highlighted, only the column and row range of the table (so this would be predefined in the VBA code). So, something similar to this: http://www.excel-easy.com/vba/exampl...tive-cell.html.

**stnkynts** · 10-03-2014, 07:09 PM

Please Login or Register  to view this content.

**Statto** · 10-03-2014, 07:25 PM

Originally Posted by stnkynts

Please Login or Register  to view this content.

Sorry, where do I put this? That was a little vague.

**stnkynts** · 10-03-2014, 11:00 PM

The website you linked tells you exactly how to do it. Read it.

**Statto** · 10-04-2014, 07:01 AM

Originally Posted by stnkynts

The website you linked tells you exactly how to do it. Read it.

Sorry, but I did read it but it didn't tell me to do what I wanted.

I found a better example: http://www.techrepublic.com/article/...al-formatting/. This is pretty much what I want. It highlights the column/row of a RANGE. I have implemented it into my own spreadsheet. The only problem with it is it highlights the column or row of the range even when you click outside that range. What I really need is to get it so it does not highlight anything within the range when you click outside of that range. So, for example, if the range is C5:G20, I only want the column/row of that range to be highlighted when the user clicks within it.

**sktneer** · 10-04-2014, 08:51 AM

This is the code for Worksheet_SelectionChange Event i.e. the code will execute once you change the selection on the sheet. You need to place this code on worksheet module. i.e. Right click on the Sheet Tab where you want this code to be executed --> View Code --> In the opened code window, paste the code if you have already copied it from somewhere or on the code window you will find two drop down with the default values General and Declarations --> Click the first drop down which has General by default and select Worksheet --> Now click on second drop down and select SelectionChange --> Now here you can write your own code for Worksheet SelectionChange Event.

To view the code in the attached sheet, right click on Sheet1 Tab --> View Code.

Hope this helps.