Re: $$Excel-Macros$$ Re: Auto highlight Row/Column of Active Cell...

HI all, This is really nice posting and solution!!! Just a query extending this macro... Is it possible to run the macro running till it is deactivated. IN short dynamic. I mean the rows and columns should be highlighted as the cursor moves. It would be great utility... rgds vi On Tuesday,

Re: $$Excel-Macros$$ Re: Auto highlight Row/Column of Active Cell...

Right click on the name sheet, then paste the following code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 Target.Interior.ColorIndex = 40 End Sub 2018-02-12 15:02 GMT+07:00 who : > Sorry for the previous post. It

$$Excel-Macros$$ Re: Auto highlight Row/Column of Active Cell...

Sorry for the previous post. It works, but also contains some experimental code which is no necessary, but I think you will see this when you try it out and will be able to fix this. If you do not see how to fix it, post and I will edit and repost. It is just pretty late here, after midnight

$$Excel-Macros$$ Re: Auto highlight Row/Column of Active Cell...

On Thursday, February 8, 2018 at 9:49:25 AM UTC-8, Robert King wrote: > > Hi Everyone > > I have a very wide sheet and sometimes it gets difficult to follow which > row contains the data I need. > > I would love it if excel could overlay shading or a colour to highlight > the row and column of