the 'formula' wont resolove using concatenate as it's text.

you have to use INDIRECT to resolve text to an actual formula.

Right at the bottom of the help file on INDIRECT is...

=INDIRECT("A10")


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=538023