converting formula values into just numbers?

[DNunley]

I need to manipulate with a macro, as absolute numbers, the numerical values
returned from a formula. Instead of say.....1,3,5,8, etc. the macro sees the
corresponding formula when referred to these cells and can't work with it.
How can I return just straight numbers from the formula calculations?

Thanks

 

[J.E. McGimpsey]

One way:

Dim myValue As Double
myValue = Range("A1").Value