Check your Define.Name dialog box. It is possible to define a name to
refer to a formula. I do this all the time to pull data out of strings
or just to replicate formulas too complex to retype, but to small to
write a U.D.F. for.
If I'm right, the "Refers To..." box will contain a formula just like
you would enter in a cell. Wherever you paste the name, the formula is
evaluated and displayed on the sheet.