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