Boy ... that takes me back a *lot* of years!<g>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bob Umlas" <rumlas@kpmg.com> wrote in message
news:%23LxE0biYFHA.796@TK2MSFTNGP09.phx.gbl...
> to display the formula in the cell to the left, for example, select cell
F1
> (arbitrary), then define a name, say Fml, and have it be:
> =GET.CELL(6,Sheet1!E1) (where E1 is a relative reference to the cell to
the
> left of the active cell).
> Then, if you enter =sum(A1:A5) in cell G12, for example, if you enter =Fml
> in cell H12, you'll see =SUM(A1:A5) displayed.
> Bob Umlas
> Excel MVP
>
>
> "Geoff" <gh@bob.com> wrote in message
> news:OrXu7WeYFHA.4032@tk2msftngp13.phx.gbl...
> > Without changing any of the options to reflect the formula in a
worksheet,
> > though an Excel worksheet function is it possible to return the formula
in
> > another cell.
> >
> > E.g.
> >
> > Cell A1=sum(a2:a200)
> > The value returned and represented in the worksheet is say 2000
> >
> > I want to return the text "=sum(a2:a200)" through a formula and not VBA.
> Any
> > ideas or suggestions?
> >
> > Thanks in advance
> >
> >
>
>