G
Guest
Hi all,
How to refer to a merged area value, only do I know is using the first
merged cell address.
Clara
How to refer to a merged area value, only do I know is using the first
merged cell address.
Clara
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
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)
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)