You'd need to use VBA. Take a look he

http://www.mvps.org/dmcritchie/excel/formula.htm

In article ,
"Gunnar" wrote:

Hi!
I wonder if it`s possible to pick up a formula from a cell:
I use this formula when I pick up regular numbers.

{=SUM(IF(Time!$A$5:$A$147=$B1178;Time!$E$5:$E$147; 0))}

In almost all the cells it`s numbers, but sometimes I the
content of the cell is like : = e12*12/10

How can make the look able to pick up formulas, or do I
have to write VBA code?