I need to set my Interior.Color.Index to 15 for every other cell in my range starting with A5, after I set my sheet to merge cells.
So far I have my code as:
Private Sub MergeBlockNames()
For i = 5 To 74 Step 2
Range(Cells(i, 1), Cells(i + 1, 1)).Merge
I am confused how to add this next step - can you please help?