Displaying formula from one workbook in another

[Barb Reinhardt]

I have the following formula in Workbook1.xls Sheet1
=offset(blah blah blah)
I want to display that formula in Workbook2.

How can I display this formula?

Thanks in advance,
Barb Reinhardt

[Peo Sjoblom]

You would need a UDF like

http://www.mvps.org/dmcritchie/excel/formula.htm

=getformula([Book2]Sheet1!$A$1)

you can make that UDF into an add-in so it is available

Or download Laurent Longre's excellent Morefunc (personally I think it is
the best add-in for Excel)

http://xcell05.free.fr/

FORMULATEXT

is the name of the function

English descriptions here

http://www.rhdatasolutions.com/morefunc/

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Barb Reinhardt" <BarbReinhardt@discussions.microsoft.com> wrote in message
news:B35267B0-93F7-4D62-9670-66E2201365C6@microsoft.com...
>I have the following formula in Workbook1.xls Sheet1
> =offset(blah blah blah)
> I want to display that formula in Workbook2.
>
> How can I display this formula?
>
> Thanks in advance,
> Barb Reinhardt