Re: SHARE VALUE IN MERGED CELLS.

["Jennings, Corey" <CDJennings@CESSNA.TEXTRON.COM>]

You could use something like:

=OFFSET(B1,0,-1)

cj

-----Original Message-----
From: J. Meng [mailto:jmeng81@HOTMAIL.COM]
Sent: Friday, July 25, 2003 7:59 AM
To: EXCEL-G@PEACH.EASE.LSOFT.COM
Subject: SHARE VALUE IN MERGED CELLS.


If I merge cells, say  A1:C1, then the value in B1, C1 will be lost. The
value shown in the merged
cells can only be refered by A1.  Is it possible when I refer B1 or C1, I
can get the same value?


thanks.

Jerry

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G