Tom,
I made the change, but it now displays the text I pass to it.

Maybe I should just take a step back and ask if there an easier way to
put together an hlookup based upon concatenating dynamic text strings
that refer to an array in another closed spreadsheet. I've tried using
Indirect, but it has the same problem.

Thanks!
Eric

"Tom Ogilvy" wrote in message ...
Evaluate won't work with a closed workbook, so that is why your A14 is
failing.

In A15, Excel evaluates the argument to myfunct before passing it to
myfunct, so it gets the results from the look up and passes it as a string
to Myfunct which does nothing to it and returns it.

change

Public Function myFunct(InputString As String)
myFunct = Application.Evaluate("=" & InputString)
End Function
to

Public Function myFunct(InputString As String)
myFunct = InputString
End Function

and you will see the difference.

--
Regards,
Tom Ogilvy