Nick,

You need to use a User-Defined Function, code given below. Copy the code
into a code module, and use it like

=IsMerged(A1)

It will return TRUE if A1 is part of a merged cell, FALSE otherwise.

HTH,
Bernie
MS Excel MVP


Function IsMerged(inCell As Range) As Boolean
IsMerged = inCell.MergeCells
End Function


"nick.pattison" wrote in message
...
I need to be able to tell if a cell at a given cell reference is part of a
merged group of cells or not