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