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
>
>