Concatenate path and file string for external reference
Use the INDIRECT function.
"Michael" wrote in message
I am trying to create a linked external reference by concatinating the
I have in 3 cells:
path file sheet
H:\Dev\ [fromModel.xls] Sheet1'!$B4
I concat them to create what should be the reference
But it just returns the string. How do I get it to evaluate?