Hi Anne, it wont matter in this case as you are simply clearing contents, but when you loop through a range it looks at every cell individually, even if the cell is merged. So if A1:A3 were merged and A4:A5 were merged then a loop through A1:A5 is looping through 5 cells not 2.

Ideally you would check to see if the cell was merged, then loop through the merged area seprately. This is just FYI...

Sub Example()
Dim Rng As Range, c As Range, cell As Range
Set Rng = Range("A1:A6")
For Each c In Rng
    'you should put an IsError check here if you are looking at cell values
    If c.MergeCells Then
            If c.Address = c.MergeArea(1).Address Then
                For Each cell In c.MergeArea
                    'do what ever to merged cell
                Next cell
            End If
    Else
        'do what ever to non merged cell
    End If
Next c
End Sub