about "indirect"

  • Thread starter Thread starter ldh
  • Start date Start date
L

ldh

HI,

=INDIRECT("'C:\Documents and Settings\04\desktop\[95.xls]
sheet1'!C"&A1)

A1=29

why don't this formula =
'C:\Documents and Settings\04\desktop\[95.xls]sheet1'!C29

thanks
LDH
 
ldh,

From first glances, it appears that it should work. But since it doesn't
work, I would to the following:

1) select in the formula bar everything in between the brackets and
including the brackets, i.e.,

("'C:\Documents and Settings\04\desktop\[95.xls]sheet1'!C"&A1)

2) Press F9 to evaluate.

Do you get the expression you had hoped for? Does A1 contain the value you
thought? You should, of course, get,

'C:\Documents and Settings\04\desktop\[95.xls]sheet1'!C29

That is how I would try to approach your problem.

Best regards,
Kevin
 
Hi

The INDIRECT function is used to get the contents of the
cell that is referenced in the detail. So if C29 in the
reference below had "fred" as its value, then the result
of the function would be "fred".

However, the INDIRECT function does not work on closed
files. If the file 95.xls was open, then the result would
be posted. If it is closed, then it will produce an error.


Tony
 
Thank you,Tony.
I think "indirect" function doesn't work in this
situation, please show me how to achieve it.
and I have 1.xls to 95.xls files.


-----Original Message-----
Hi

The INDIRECT function is used to get the contents of the
cell that is referenced in the detail. So if C29 in the
reference below had "fred" as its value, then the result
of the function would be "fred".

However, the INDIRECT function does not work on closed
files. If the file 95.xls was open, then the result would
be posted. If it is closed, then it will produce an error.
Tony
-----Original Message-----
HI,

=INDIRECT("'C:\Documents and Settings\04\desktop\[95.xls]
sheet1'!C"&A1)

A1=29

why don't this formula =
'C:\Documents and Settings\04\desktop\[95.xls]sheet1'!C29

thanks
LDH
.
Click to expand...
.
Click to expand...
 
Back
Top