VBA: How to detect whether two cells are currently merged
 

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

Thanks!
Elieze

--
Message posted from http://www.ExcelForum.com

How to detect whether two cells are currently merged
 

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)

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

Thanks!
Eliezer


---
Message posted from http://www.ExcelForum.com/

How to detect whether two cells are currently merged
 

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" wrote in message
...
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)

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

Thanks!
Eliezer


---
Message posted from http://www.ExcelForum.com/

VBA: How to detect whether two cells are currently merged
 

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

TH

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

On 4/15/04 15:40, in article , "Lazer "
wrote:

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

Thanks!
Eliezer

---
Message posted from http://www.ExcelForum.com/