I use the VBA solution from Pecoflyer's post from 10-23-13 to highlight the row of the current cell and it works. However, if any of the cells are highlighted it removes the highlighting. Is there a ways to highlight the row of the current cell without removing any previous highlights?

Edit mod : related to https://www.msofficeforums.com/excel...nt-cell-3.html