How do I use "paste special" inside a formula?
 

How can I tell a formula (that calculates other cell values) to return
(paste) only the formula's value and not formula result? In other words, if
you double click on the result, you will not be shown the formula, rather the
value.
Thanks alot!!!

How do I use "paste special" inside a formula?
 

You would need to use a macro to place the value.
range("a2").value=range("a3")*range("a4")

--
Don Guillett
SalesAid Software

"Dov A." <Dov wrote in message
...
How can I tell a formula (that calculates other cell values) to return
(paste) only the formula's value and not formula result? In other words,
if
you double click on the result, you will not be shown the formula, rather
the
value.
Thanks alot!!!

How do I use "paste special" inside a formula?
 

Cannot be done through a formula.

A cell contains a formula or a value.

Copy then Paste SpecialValuesOKEsc.


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 06:29:00 -0800, Dov A. <Dov
wrote:

How can I tell a formula (that calculates other cell values) to return
(paste) only the formula's value and not formula result? In other words, if
you double click on the result, you will not be shown the formula, rather the
value.
Thanks alot!!!