IIRC an Excel aficionado named Ivan Moala developed such a utility about a decade ago. It would highlight the entire selected column & row, then restore the original formatting once you moved to another cell. IIRC there was a noticeable delay when changing cells, as the code had to: a) search the entire column & row for any existing highlights, so they could be saved; b) restore the highlight states for every cell in the exited row/column; c) re-save the highlights for any cell whose column/row overlapped the previous active cell's column/row; and, finally, apply the temporary highlights. Even that didn't try to preserve existing highlights while the column/row was 'active'. With modern workbooks having so many more rows & columns to handle, I wouldn't be surprised if the task became unmanageably slow.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yeah, but Dee is saying the goal is to highlight the row of the selected cell "without losing any previous highlighted cells"; that sounds like all that's needed is my one-statement code snippet below. Granted, that's much too simple; it would end up highlighting every row just from scrolling the cursor up and down.

Dee, your sample just shows a highlighted cell; it doesn't illuminate me much. You say my solution "didn't work"—but how did it not work? Did it bomb with a message? Fail to do anything at all? Do something but not what you wanted? What?