Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: copy and paste function

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    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

  3. #3
    Join Date
    Mar 2004
    Posts
    361
    is that a function? How would I type that into the cell. Sorry for the dumb question.

  4. #4
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    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

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    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
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  6. #6
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    You can change the format to text and pasting

    HTH
    texasalynn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •