Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    ref a formula as text (2002+)

    Suppose I have a formula in a cell (e.g., A10 is =sum(A1:A9).

    Is there a way to get the text equivalent of that formula in another cell without using a macro? =A10 gives the result, not the formula. =CELL doesn't seem to have an option to grab the formula itself as text.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: ref a formula as text (2002+)

    You can use a defined name with the GET.CELL Excel4 macro function. If it's just one cell, you would define the name (let's call it GetFormula) as:
    <code>=GET.CELL(6,$A$10)</code>
    and then just use <code>=GetFormula</code> in a cell. You can also select cell B1, and define the name as <code>=GET.CELL(6,A1)</code> and then it will always refer to the cell to the left of where it is used in a formula.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Re: ref a formula as text (2002+)

    I keep forgetting about Excel4...wonder why MS didn't just put a nice collection of functions in newer releases to help fading memories like mine.

    Where might there be a good summary of the old Excel4 commands like this one, etc.??

    Thanks.

    KRW

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ref a formula as text (2002+)

    The Excel 4 macro help file can still be downloaded from Microsoft: Macrofun.exe File Available on Online Services.

Posting Permissions

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