30875138

[VikiKosta]

Hey,

How can I get the value of specific cell if i got the address a
string?
What i mean is i need to get the value form another Workbook into on
that i working with when the cell location is set by the user.

thank

 

[Govind]

Not sure what you want.

If you have the address as a string and want the value of that cell, try
using the indirect function

Regards

Govind.

 

[Max]

In Book2.xls, try something like:

=INDIRECT("'["&"Book1.xls"&"]"&"Sheet1"&"'!$A$1")

to extract value from Sheet1's cell A1 of Book1.xls

Note: Book1.xls has to be *open* for the formula in Book2.xls
to work, otherwise you'll get #REF!