Results 1 to 2 of 2
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Function to extract Formula (2003/SP2)

    I'm having a drop out or perhaps it is because I'm also trying to play with 2007 simultaneously. I'm trying to remember a function that will allow me to reference the formula in another cell, not the result.
    My goal: I have multiple references to external workbooks in this file. I want a double check that cells in each row are referring to the same external file.

    TIA
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Function to extract Formula (2003/SP2)

    What about pressing ctrl+` (the key above the <!t>[tab]<!/t> key) to display the formulas and then pressing it again to hide them again.

    I don't think there is a built in function that will display the formula otherwise. You could create your own. I use:

    <pre>Function ShowMe(Ref As Range) As String
    Application.Volatile
    ShowMe = Ref.Formula
    End Function
    </pre>


Posting Permissions

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