Merge question
 

Let's say I'm referencing cell A2 and am calling it myRange. How do I find
out the other cells that are merged with A2 programmatically?

Thanks in advance,
Barb Reinhardt

Merge question
 

Additional comment. Keep in mind that cells around it may be merged with
this cell or merged with other cells.

"Barb Reinhardt" wrote:

Let's say I'm referencing cell A2 and am calling it myRange. How do I find
out the other cells that are merged with A2 programmatically?

Thanks in advance,
Barb Reinhardt

Merge question
 

msgbox myRange.MergeArea.Address

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote:

Let's say I'm referencing cell A2 and am calling it myRange. How do I find
out the other cells that are merged with A2 programmatically?

Thanks in advance,
Barb Reinhardt

Merge question
 

Hi Barbara

?Range("A1").mergearea.address

$A$1:$B$4


---
Regards,
Norman


"Barb Reinhardt" wrote in message
...
Let's say I'm referencing cell A2 and am calling it myRange. How do I
find
out the other cells that are merged with A2 programmatically?

Thanks in advance,
Barb Reinhardt