Are you using Indirect in your formula. Indirect doesn't work with closed
workbooks.

--
Regards,
Tom Ogilvy


"tjh" wrote in message
...
At one point in one of my macros, I open another Excel File (I will call
this
newly opened file FileO to make this read easier).

The macro then changes a Vlookup formula in the current file to link to a
range in FileO.
The formula is then Re-Calculated.

The macro then closes FileO. And the macro stops, with the current file
still open.

When I close FileO the current file's Vlookup formula gives a reference
error, if I
recaluclate. But it works fine if FileO is open.

Is there an option I need to change? Or is this something that happens
when
you use a Vlookup to another file? I have not used many Vlookups with
other
files in the past, normally just the current file.

Thank You,