[AccessD] Excell Question on Reference to Named Cell

Keith Williamson Kwilliamson at RTKL.com
Mon Jun 18 16:34:20 CDT 2007


Does anyone know how to merge text, to create a reference to a named
cell in excel?

I am trying to pull in Cell A1="V:\Finance\GL_Sched\Assoc\[124.01
Clearing.xls]!" 

Cell A2="May"

I want to merge the two:

V:\Finance\GL_Sched\Assoc\[124.01 Clearing.xls]!May

Which would reference a cell, named "May" on another worksheet.  When I
try this, no matter what I do...excel treats this as text....and won't
bring back the value of "May" from the other worksheet.

Anyone know what I can do?

Thanks,

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-4182 fax | www.rtkl.com 
--------------------------------------------------------------------------------
The information contained in this communication is confidential, may be privileged and is intended for the exclusive use of the above named addressee(s). If you are not the intended recipient(s), you are expressly prohibited from copying, distributing, disseminating, or in any other way using any of the information contained within this communication. If you have received this communication in error, please contact the sender by telephone at (410) 537-6000 or by response via e-mail and permanently delete the original email and any copies.




More information about the AccessD mailing list