30875138

  • Thread starter Thread starter VikiKosta
  • Start date Start date
V

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
 
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.
 
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!
 
Back
Top