Sorry for the delay in getting back (went to bed for the night).
Credit for this solution goes to whoever won the "I was first" debate at the link I provided, not Me.
I thought this was quite nifty when I saw it so tucked it away for future reference.
Hopefully you've experimented with the macro and by now satisfied the additional requirements.
If not, change the name of the sub to something like Public Sub Highlight_Row()
and in the Intersect line change Target to ActiveCell
|