excel formla to take variable

[eHanSolo]

hi all,

was wondering if it was possible for a worksheet formula to take in a variable specified by a cell.

for example:

range(A1).value would contain something like: 'MyFile.xls'

then i'll have a formula like:

=sum('networkpath here' & range(A1))

possible??

e

 

[xlbo]

use the INDIRECT funtion - caveat - it will not work on a closed workbook...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[firefytr]

If you do want to use a function for a closed workbook, google Harlan Grove's Pull function, or lookup the INDIRECT.EXT function on Laurent Longre's morefunc.xll addin.

-----------
Regards,
Zack Barresse

 

[eHanSolo]

thanks all!!

e