RE: Merged Cells Value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
>
>
.

Relevant Pages

  • Re: Add/Remove Programs
    ... 226."Remove the White Space from ... there is a huge gap between the first few installed programs listed and the ... Is there a fix for this problem? ...
    (microsoft.public.windowsxp.general)
  • Re: OT: What if things were switched around?
    ... Assuming McCain picked Palin on the basis of a 'gap' analysis, well, ... it seems you could drive a truck through this one. ... Best regards ... John> ...
    (rec.music.opera)
  • Re: How can I select an element that doesnt exists in a table?
    ... Laurenz Albe wrote: ... if the gap occur at the highest end of your sequence, do you consider this to be a gap or not)? ... Best regards ...
    (comp.databases.oracle.misc)
  • Re: OT: What if things were switched around?
    ... Assuming McCain picked Palin on the basis of a 'gap' analysis, well, ... it seems you could drive a truck through this one. ... Best regards ...
    (rec.music.opera)
  • 2 sec gap
    ... I downloaded and installed the nero plug in, but don't know how to prevent the 2 sec gap when recording to cd... ... Regards ...
    (microsoft.public.windowsmedia.player)