Test for Merge

[Guest]

What is the easiest way to code a Boolean UDF that, given a range as input,
will return TRUE if any cell in that range is merged and FALSE otherwise?

 

[Guest]

Hi,

Try this:

=isMerge(A1:H1) in required cell

Function IsMerge(inRng)
For Each cell In inRng
If cell.MergeCells Then
IsMerge = True
Exit Function
End If
Next cell
IsMerge = False
End Function

 

[Guest]

Thanks a lot. I now have a better test for "sortability"