How to get the value of a meged cell
 

Hi,

How to get the value of a nerge cell when refering to a address within the
merged Cell.

Exemple:

Cells B1 - E1 are merged. In a macro I refer to cell D1 and I would like to
have the value of the merged cell, which in fact is B1.value (D1.value is
empty)

nde

How to get the value of a meged cell
 

On Thu, 8 Mar 2007 12:28:34 -0800, nde
wrote:

Hi,

How to get the value of a nerge cell when refering to a address within the
merged Cell.

Exemple:

Cells B1 - E1 are merged. In a macro I refer to cell D1 and I would like to
have the value of the merged cell, which in fact is B1.value (D1.value is
empty)

range("D1").MergeArea.Cells(1).value

--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com

How to get the value of a meged cell
 

You answered your own question he


"nde" wrote:


Cells B1 - E1 are merged. In a macro I refer to cell D1 and I would like to
have the value of the merged cell, which in fact is **B1.value** (D1.value is
empty)

How to get the value of a meged cell
 

Not exactly, look at Dick's answer, this is what I was looking for.

nde

"Wood Grafing" wrote:

You answered your own question he


"nde" wrote:


Cells B1 - E1 are merged. In a macro I refer to cell D1 and I would like to
have the value of the merged cell, which in fact is **B1.value** (D1.value is
empty)

How to get the value of a meged cell
 

Thanks,

This is what I was looking for !

nde

"Dick Kusleika" wrote:

On Thu, 8 Mar 2007 12:28:34 -0800, nde
wrote:

Hi,

How to get the value of a nerge cell when refering to a address within the
merged Cell.

Exemple:

Cells B1 - E1 are merged. In a macro I refer to cell D1 and I would like to
have the value of the merged cell, which in fact is B1.value (D1.value is
empty)

range("D1").MergeArea.Cells(1).value

--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com