On Jan 13, 12:19*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Use the INDIRECT function.
--
David Biddulph

"Michael" wrote in message

...



I am trying to create a linked external reference by concatinating the
info together.
I have in 3 cells:

path file sheet
H:\Dev\ [fromModel.xls] Sheet1'!$B4

I concat them to create what should be the reference
='H:\Dev\[fromModel.xls]Sheet1'!$B4

But it just returns the string. How do I get it to evaluate?- Hide quoted text -

- Show quoted text -

I cant seem to get indirect to work. Can someone give me an example of
how it would work with the concatenation of the path\file\sheet
\cellref.
Also is there a way to make the string with the = sign in front of it
evaluate instead of returning the concatenated string (a way around
indirect)?
thanks.