Hi!

What's your formula look like?

An "educated guess" : You can't "build" a formula by concatenating a bunch
of expressions!

Biff

"Jonrey" wrote in message
...
I am compiling data from several different, variable, worksheets. I am
using
concatenate to add the name of each worksheet into a formula to pull the
appropriate data. However, it is returning the text of the formula instead
of
the results of the formula. How can I make it calculate the result instead
of
simply displaying the formula text?