Johnny,

I think you're stuck with parsing the formula. RegExp may help, as
suggested by John C.

On the other hand, can you just copypastevalues the whole sheet? If you
freeze only some of the formulas then how does the user know which values
are "live" and which are not (so they know which inputs they can change and
still get correct values)?


Tim


"Johnny Meredith" wrote in message
oups.com...
Yes it should be forzen. It's a wrapper for queries in an accounting
system, and the ultimate recipient of the sheet (who does not have the
addin that makes the account system query wrappers possible) will get a
#NAME? error. See also my new post below in response to John Coleman.

Thanks,
Johnny