![]() |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
NoSparks.....I failed to recognize the change "Target to ActiveCell requirement.
After incorporating your solution my goal has been accomplished. You may not want credit for the solution, but as far as I am concerned, YOU resolved my issue. Thank you for taking the time to assist me. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C
|
rick10r | Excel | 1 | 07-05-2016 12:07 PM |
| Dymanic Range Starting at a Cell Defined by a Count | jap7675 | Excel Programming | 7 | 12-02-2015 02:12 AM |
If id cell range is empty then should not allow to fill any other cell
|
ubns | Excel Programming | 2 | 04-12-2015 06:31 AM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |