Please help

  • Thread starter Thread starter howiechc
  • Start date Start date
H

howiechc

Hi,


May I know how to create a variable that links to a cell?

What I meant is I have a list that looks like this :

indo : indo.xls

sg : na.xls

india : na.xls

tw : na.xls

thai : na.xls

Is there are a in which I could make indo,sg,india,tw and thai as
variable in which I could use for the entire book? in which will parse
the value that is define by the user in this case the variable indo
will pasrse me the value/string indo.xls

Is it possible? Please help. Thanks in advance.


Cheers,
Howie
 
Choose Insert/Name/Define. Enter

indo

in the Name in Workbook field, and

="indo.xls"

in the Refers To: field. Click Add.

Then in your workbok, you can use "indo" as a substitute for "indo.xls":

=INDIRECT("'[" & indo & "]Sheet1'!A1")
 
Back
Top