VBA: How to detect whether two cells are currently merged

[Lazer]

Using VBA, how can I determine whether two cells (let's say F8 and F9
for example) are currently merged?

Thanks!
Elieze

 

[Bob Phillips]

Range("F8").merge.address<>Range("F8").address

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Sorry, should be

Range("F8").mergearea.address<>Range("F8").address


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Range("F8").merge.address<>Range("F8").address

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[TH]

Go to Excel HELP and type
mergecells property
In the Answer Wizard section.

TH

Cells(ActiveCell.End(xlDown).Row + 1, ActiveCell.Column).Select