Back to VBA, haven't touched it in a few years.
I have a larger project in mind but one step at a time.
I basically need to find any merged cell across rows only. Then identify all the rows that are included in that merged cell.
To do this I just want to change the color for now to test the code.
What I have that isn't working:
Dim Row as Range
For each Row in Selection
If Row.Merged = True Then