VBA: How to detect whether two cells are currently merged

L

Lazer

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

Thanks!
Elieze
 
B

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)
 
B

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)

Bob Phillips said:
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)
Click to expand...
 
T

TH

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

TH

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