how to refer to a merged range value

G

Guest

Hi all,

How to refer to a merged area value, only do I know is using the first
merged cell address.

Clara
 
G

Guest

If you know the first cell address of a merged area, simply use its value
And if you do not know the address of the first cell, you can obtain the
value of the merged area in this way Range(“A!â€).MergeArea(1).Value. Instead
of “A1†you should use the address of any cell which is a part of the merged
area.
 
C

Chip Pearson

Clara,

Use the MergeArea property. E.g.,

Debug.Print Range("C10").MergeArea.Address


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)
 

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
target.offset(0,-1) does not work as assumed 3
Merged Cells ' Range height 1
How to get the value of a meged cell 4
populate cells within merge area 5
Strip out certain rows that have merged cells 2
Access to the value of a merged cell in a formula 8
Find a merged cell 3

Top