searching merged cells

Originally Posted by chris_mayer

Hi

Sorry, only used that as an example for ease of explanation. My merged cells are made up different numbers of merged cells so that wouldn't work :-(

Aaaha - ok

You can cycle through the range of cells and test if each is a part of a Merge, as per the help on 'Merged' -
Set ma = Range("a3").MergeArea
If Range("a3").MergeCells Then
ma.Cells(1, 1).Value = "42"
End If

but you would need a serious reason to do that.

---