In a standard Module paste in

Sub UnmergeCells()
With Range("a1") 'change cell reference accordingly
If .MergeCells Then
.MergeArea.UnMerge
Else
MsgBox "not merged"
End If
End With
End Sub


"jacknthbox" wrote:

I removed hyperlinks which apply anytime you add text with the @ sign or .com
it makes it really difficult to format a quick reference. i removed the
hyperlinks and the borders disappear and it seems the cells are merged...this
is way annoying...anyone have answers