ExcelBanter - View Single Post

paul

http://www.dailydoseofexcel.com/arch...sed-workbooks/
try this function called indirect.ext
--
paul

remove nospam for email addy!

"Hurtige" wrote:

Im really in need of some good advice. Ive used many hours making a test
cell for a new worksheet, but then when i closed down the workbooks my
test cell was refering to i got the #REF! error although the whole path
to the workbook was there. I isolated the problem to a indirect formula
im using because i want the reference file to be a variable.

How do i solve the problem that excel isnt able to use a cell reference
in a workbook that isnt open if that reference is within a "=indirect()"
code..?

--
Hurtige
------------------------------------------------------------------------
Hurtige's Profile: http://www.excelforum.com/member.php...o&userid=37381
View this thread: http://www.excelforum.com/showthread...hreadid=571282