absolute numbers from formulas

[DNunley]

I need to be able to apply a macro to cells containing numeric values of a
formula, but need the values to be identified in the cell as just numbers,
not the results of a calculation. I.E. macro needs to "see" values 1,2 3,
etc. NOT =SUM(d2:f2), etc. when it looks at the specific cells. How can I
convert these formula calcs into just plain old numbers?
Thanks

 

[J.E. McGimpsey]

The results of a calculation *are* numbers, so I'm not sure what
you're getting at.

You can use the .Value property of a cell:

Cells(1, 1).Value

or

Range("B1").Value

and if the cell has a formula, the .Value property will return the
result of the calculation.

 

[Rick Sanderson]

If im hearing you correctly what i do is to
'copy' the cell contents,
'paste special' into the same cell with a tick in 'values'

Regards,
Rick

DNunley wrote:
|| I need to be able to apply a macro to cells containing numeric
|| values of a formula, but need the values to be identified in the
|| cell as just numbers, not the results of a calculation. I.E. macro
|| needs to "see" values 1,2 3, etc. NOT =SUM(d2:f2), etc. when it
|| looks at the specific cells. How can I convert these formula calcs
|| into just plain old numbers?
|| Thanks

 

[DNunley]

Thanks Rick, this worked just fine. Dave