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/