View Single Post
 
Old 02-05-2017, 08:03 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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
Reply With Quote