| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to refer to a merged range value
Hi all,
How to refer to a merged area value, only do I know is using the first merged cell address. Clara -- thank you so much for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to refer to a merged range value
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. "clara" wrote: Hi all, How to refer to a merged area value, only do I know is using the first merged cell address. Clara -- thank you so much for your help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to refer to a merged range value
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) "clara" wrote in message ... Hi all, How to refer to a merged area value, only do I know is using the first merged cell address. Clara -- thank you so much for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to refer to a range except one cell | Excel Discussion (Misc queries) | |||
| refer to range in another sheet | Excel Discussion (Misc queries) | |||
| Pivot tables to refer to merged cells | Excel Discussion (Misc queries) | |||
| Refer to rows in a range | Excel Programming | |||
| How do I refer a Range to a Cell | Excel Worksheet Functions | |||
Linear Mode
