Just some added info:
Simplifying to [A1]
is not recommended (in my opinion) as it is many times slower

--
Regards,
Tom Ogivly

"Niek Otten" wrote in message
...
?Range("A1").Value
Since Value is default for a formula, you can also use
?Range("A1")
Which can be simplified to
?[A1]

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"crusoe81" wrote in message
...
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