How can i decide whether a range of cells are merged or not?

[Guest]

Pls.... help

 

[Audiojoe]

You can right click on the suspected area, then choose Format Cells. Go to the Alignment Tab, and if there is a tick in the Merge Cells box then they're merged

 

[Guest]

The MergeCells property will tell you whether there are any merged cells in a range.

 

[Barry Katcher]

[No message]

 

[Barry Katcher]

When you click on any of the suspected cells, if they are merged, the cell outline will include all of them. If you have your grid turned on, the grid will show you which cells are merged.

 

[Mudface]

The function below will return true or false if any cells are merged within the range you want to check: -

Public Function IsItMerged(myRange As Range) As Boolean
Dim c As Range

For Each c In myRange
If c.MergeCells Then
IsItMerged = True
Exit Function
End If
Next c

IsItMerged = False

End Function

 

[Guest]

Thx all, Thx Mudface!!! That's the answer
Even though i haven't state the question clearly, you can get what i mean!! Great!!