Highlight current row / column

Occasional Contributor

How do you highlight the current row/column?


I found this https://docs.microsoft.com/en-us/office/vba/excel/Concepts/Cells-and-Ranges/highlight-the-active-cel... but it wipes out formatting, and disables ctrl-z!!!  Without even a warning..


There must be some way to simply highlight the whole row/column, just as the current cell.



1 Reply


See the free Follow Cell Pointer add-in from Jan Karel Pieterse's download page