paste special "values" work fine as a manual solution but how can I assign an
instantaneous cell value as part of as formula?

"Ron Coderre" wrote:


Try this:

Select the source cells
EditCopy
Select the destination cell
EditPaste Special
Check: Values
Click the [OK] button

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=499894