How to get the value of a meged cell

G

Guest

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
 
D

Dick Kusleika

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)
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Change size of font if cell value is greater than 0 2
length of line depending on the value of the cell 13
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Cells with varying number of lines 1
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? 2
Accessing The Value Of A Merged Cell 9
Access to the value of a merged cell in a formula 8

Top