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

2018-02-14 Thread Vishwanath
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, Fe

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

2018-02-12 Thread Bé Trần Văn
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 works, but also contains so