View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crusoe81 crusoe81 is offline
external usenet poster
 
Posts: 1
Default 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