Hi

Copy cell A2, and PasteSpecial Values
From Edit menu, Replace '=' with '='


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"dodger" wrote in message
...
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 ?