| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merged Cells Value
Hello,
If A1:C1 are merged cells, why is the value of B1 & C2 null and only A1 has the value? How to get the value set in the merged cells if I have a reference to say B1 or C1 here? Tks & Regds Gap |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merged Cells Value
When dealing with merged cells (I avoid them at all costs; too
much trouble with cut/paste, sorting, etc), you reference the top left cell in the merge area, and ignore the other cells. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Gap" wrote in message oups.com... Hello, If A1:C1 are merged cells, why is the value of B1 & C2 null and only A1 has the value? How to get the value set in the merged cells if I have a reference to say B1 or C1 here? Tks & Regds Gap |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merged Cells Value
Because only A1 holds the value. But you can use:
set rng= Range("B1") msgbox rng.mergearea(1).Value -- Regards, Tom Ogilvy "Gap" wrote in message oups.com... Hello, If A1:C1 are merged cells, why is the value of B1 & C2 null and only A1 has the value? How to get the value set in the merged cells if I have a reference to say B1 or C1 here? Tks & Regds Gap |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merged Cells Value
Tru:
MsgBox Range("B1").MergeArea(1, 1).Value Regards, Greg "Gap" wrote: Hello, If A1:C1 are merged cells, why is the value of B1 & C2 null and only A1 has the value? How to get the value set in the merged cells if I have a reference to say B1 or C1 here? Tks & Regds Gap |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy paste non merged to merged cells | Excel Worksheet Functions | |||
| How can I sort an Excel Doc containing merged & non-merged cells? | Excel Discussion (Misc queries) | |||
| Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Hybrid Mode
