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/