Help Required.
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help Required.

  1. #1
    Guest

    Default

     
    Is it possible to dynamically create a function in a cell?

    I know that it is possible to do this for simple functions such as:

    ActiveCell.FormulaR1C1 = "=COS(8)"

    will set the cell to =COS(8)

    However, I would like to make cell A2 contain the function:

    =LOOKUP(A1,'[MyFile.xls]AllSites'!$A$4:$A$15,'[MyFile.xls]AllSites'!$B$4:$B$15)

    Where I control MyFile.xls via a variable or another cells contents.

    I have been able to make the cell contents equal the following TEXT:

    "LOOKUP(A1,'[MyFile.xls]AllSites'!$A$4:$A$15,'[MyFile.xls]AllSites'!$B$4:$B$15)"

    where MyFile.xls is actually the contents of another cell.
    However, this is just text as there is no '=' sign to make it a function.

    I can manually select the cell and add the '=' sign and it will work as I want it. Unfortunately, i can't seem to do this automatically.

    Any bright ideas people?

    Many Thanks.



  2. #2
    Guest

    Default

    Can anyone help on this?

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,809
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-03-15 00:58, Anonymous wrote:
    Can anyone help on this?
    Is this not the same question as the one at:

    http://mrexcel.com/board/viewtopic.p...c=2170&forum=2

    If so, did you try out Longre's EVAL?

    If it's not the same question, I'd suggest to have a look at that.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com