C Casc Sep 17, 2003 #1 I want to check the property of a cell to see if it is merged. Does anybody know how to write the code for this? Thanks Casc
I want to check the property of a cell to see if it is merged. Does anybody know how to write the code for this? Thanks Casc
T Tom Ogilvy Sep 17, 2003 #2 Sub aa_tester6() Dim rng As Range Set rng = Range("A1") If rng.MergeCells Then MsgBox rng.Address & " is in the merged area " _ & rng.MergeArea.Address Else MsgBox rng.Address & " is not in a merged area" End If End Sub
Sub aa_tester6() Dim rng As Range Set rng = Range("A1") If rng.MergeCells Then MsgBox rng.Address & " is in the merged area " _ & rng.MergeArea.Address Else MsgBox rng.Address & " is not in a merged area" End If End Sub
