Thread: Evaluating results of a concatenate formula, as a formula
View Single Post
  #1   Report Post  
dodger
 
Posts: n/a
Default Evaluating results of a concatenate formula, as a formula
I have this formula in cell A2.
="='[Register " & VarName & ".xls]Monthly'!$D$20"

Cell B1 has a range name of "VarName" and it contains "2005a".

The result I get is a string:
='[Trust Register 2005a.xls]Monthly'!$D$20

Rather than displaying the string, I want the string to evaluate as a fomula.

Any ideas ?
Reply With QuoteReply With Quote