Updating active cells in vba
See screenshot: Kutools for Excel includes more than 120 handy Excel tools. Download the free trial now The following VBA code can help you automatically highlight the entire column and row of the current cell, please do with following steps:1. Color Index = xl None End With End If p Row = Selection. Column x Row = p Row x Column = p Column With Columns(p Column). You can only highlight row of selected cell by choosing the Straight line option: You can only highlight column of selected cell by choosing the Vertical line option: Notes:1.Hold down the ALT F11 keys, and it opens the Microsoft Visual Basic for Applications window.2. You can cancel this utility by unchecking the Reading Layout under Reading drop down list.2.
Code: 'Delete garbage at the bottom: 1) Range("A1").
This is Microsoft's Getting Started with VBA guide.
I would highly recommend taking a look through it and understanding the code you have.
When you view a large worksheet with numerous data, you may want to highlight the selected cell’ row and column so that you can easily and intuitively read the data to avoid misreading them. And it will be dynamically moved as the selected cells change.
Here, I can introduce you some interesting tricks to highlight the row and column of the current cell, when the cell is changed, the column and row of the new cell are highlighted automatically as following screenshots: Auto-highlight row and column of selected cell with VBA code One click to highlight row and column of selected cell Kutools for Excel's Reading Layout utility helps you quickly highlight row and column of selected cell in Excel. See screenshots: Tip: You can set some attributions for this Reading Layout feature in the Reading Layout Settings dialog box, please click Kutools Reading Layout Settings to open the Reading Layout Settings dialog box.