|You have totally confused me. It was understandable when you said you wanted to select cells that were highlighted in yellow.|
But this makes no sense:
I need a way to start off the night selecting the specific cells I will be working with, then being able to select them all later when I need them to be selected.
The code I posted will select all of the Yellow cells within the range specified.
If you want to select all of the Yellow cells within a range that you have already selected in the worksheet, try this:
'Loop through selected range
For Each c_cell In Selection
'If cell is yellow, add it's address to the string
If c_cell.Interior.ColorIndex = 6 Then
tmpRng = tmpRng & c_cell.Address & ","
'Strip off extra comma from string
myRng = Left(tmpRng, Len(tmpRng) - 1)
'Select the range
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.