Indirect function
 

Hi
see the following thread for some alternatives:
http://tinyurl.com/2c62u

--
Regards
Frank Kabel
Frankfurt, Germany

"Dean Phillips" schrieb im
Newsbeitrag ...
Hi,

As the known problem with INDIRECT is that the source worksheet has
to be open, has anyone got a bit of vba that will convert the cell
formula to the resolved indirect formula?

I have a spreadsheet that summarises several other files and the
indirect formula works but I don't want to email the source files as
they are too big. If the indirect formula were converted to hardcoded
links I could 'break links' to convert the cells to values.