Get Formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I use the following VBA

Function GetFormula(Cell as Range) as String
GetFormula = Cell.Formula
End Function

When inserting =Getformula(A5) it actually returns the formula in writing like
"=A3*B3"

I would like to incoorparate the following

Make the code working when using vlookup to select the cell
=Getformula(Vlookup,A20,.......))

Retrun the actual working formula not the text, as I will have formula's in
a lookup table using the ROW() refference the make thins working.


Thanks,

W:-)
.

Relevant Pages

  • Re: Writing idiomatically for the cello and other string instruments
    ... writing for string instrument, specifically the cello. ... Also, get with a cello player and talk, ... Most of us sadly dont have a string player easily available- ...
    (rec.music.theory)
  • Re: Rewrite last line in text file
    ... Now parse the buffer backwards, ... TFileStream to that point ... start writing your replacement string. ...
    (borland.public.delphi.language.objectpascal)
  • Re: How to edit a large xml file (250MB)?
    ... I also have no access to editor which exported mentioned xml file. ... inserting and deleting some lines of text; writing something)" is very fast. ...
    (comp.text.xml)
  • How good is PERL at searching ASCII files?
    ... some text manipulation that needs doing and I've heard many times that ... or should I just spend 3 or 4 hours writing ... segregate the three param calls from the two param calls. ... The key elements being the string CONVERT, ...
    (perl.beginners)
  • How good is PERL at searching ASCII files?
    ... some text manipulation that needs doing and I've heard many times that ... or should I just spend 3 or 4 hours writing ... segregate the three param calls from the two param calls. ... The key elements being the string CONVERT, ...
    (comp.lang.perl.misc)