copy and paste function

tjarvas · #1 (**permalink**) 03-30-04, 10:40

Is it possible to paste a function in a cell and have it show the actual function instead of the result? I am using Excel 2000.

Mowgli212001 · #2 (**permalink**) 03-30-04, 10:53

try this

Dim Val1

Val1 = Range("A1").FormulaArray
Range("B1").Value = Mid(Val1, 2, Len(Val1))

where A1 contains the formulae, & B1 is where you want the description

tjarvas · #3 (**permalink**) 03-30-04, 12:03

is that a function? How would I type that into the cell. Sorry for the dumb question.

Smitty · #4 (**permalink**) 03-30-04, 13:29

He gave you a macro solution.

Ope the VB Editor by hitting ALT+F11. Goto Insert-->Module and paste this in the new module window that opens:

Code:

Sub ShowFormula()
    Dim Val1

    Val1 = Range("A1").FormulaArray
    Range("B1").Value = Mid(Val1, 2, Len(Val1))

End Sub

Then exit VBA (ALT+Q) and on your sheet goto Tools--Macro-->Run.

Any formula in Cell A1 will appear as text in cell B1.

Hope that helps,

Smitty

shades · #5 (**permalink**) 03-31-04, 08:53

Or you can download this free add-in and it has a formula called FORMULATEXT (as well as many others).

http://longre.free.fr/english/index.html

texasalynn · #6 (**permalink**) 04-01-04, 11:41

You can change the format to text and pasting

HTH
texasalynn

Internet Services

Web Development

Digital Marketing

Consumer Tech