W
willemeulen
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
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