Getting only value out of a formula
Hi
I have a formula in a cell, but i want only the result of the formula
for my macro. Is there a way for me to reference the value in the cell
e.g
Let say A1 contains "=1+1"
how can i get the value 2 from cell A1 from VBA
|