Return a formula as text string to a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharon - 18 Apr 2006 16:51 GMT

Hi - I would be really grateful if anybody knows a function to return the
formula contained in one cell to another cell as a text string?

Thanks

Signature

Sharon

Reply to this Message

Gary''s Student - 18 Apr 2006 17:23 GMT

Try this tiny UDF:

Function textit(r As Range) As String
textit = Chr(39) & r.Formula
End Function

If A1 has a formula, then =textit(A1) will display it

Signature

Gary''s Student

> Hi - I would be really grateful if anybody knows a function to return the
> formula contained in one cell to another cell as a text string?
>
> Thanks

Reply to this Message

Don Guillett - 18 Apr 2006 17:27 GMT

Put this in a REGULAR code module and then just type =stringit(c4)

Function stringit(x)
stringit = x.Formula
End Function

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi - I would be really grateful if anybody knows a function to return the
> formula contained in one cell to another cell as a text string?
>
> Thanks

Reply to this Message

Peo Sjoblom - 18 Apr 2006 17:32 GMT

There is no such beast but you can roll your own

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

Signature

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

> Hi - I would be really grateful if anybody knows a function to return the
> formula contained in one cell to another cell as a text string?
>
> Thanks

Reply to this Message

Sharon - 18 Apr 2006 17:40 GMT

Thanks to y'all!! Really hit the spot.

Signature

Sharon

> There is no such beast but you can roll your own
>
[quoted text clipped - 4 lines]
> >
> > Thanks

Reply to this Message