Hi,

I have a range of formulas which look up values from another sheet.
Once certain formulas evaluate, I would like those to be static. Is it
possible to have the formula change to just the value at this point,
perhaps by using a macro or some Excel function?

The only way right now I know of is to use the Paste Special option and
just paste the values.

Thanks


--
workerboy
------------------------------------------------------------------------
workerboy's Profile: http://www.excelforum.com/member.php...o&userid=34121
View this thread: http://www.excelforum.com/showthread...hreadid=569535