Replacing Formulas with Values
 

ActiveCell.formula = ActiveCell.Value

would replace the cell with the value produced by the link.

Replace activeCell with a reference to the cell with the link.

--
Regards,
Tom Ogilvy

"Raman325" wrote in
message ...

Hi, I would like to replace a formula that brings in a value from a
linked cell into the value of the linked cell. Is there a way to do
this? Thanks in advance.

Raman


--
Raman325
------------------------------------------------------------------------
Raman325's Profile:
http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=396167

Replacing Formulas with Values
 

Thanks. I tried doing that before and it wasn't working. Maybe I'm doin
something else wrong

--
Raman32
-----------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474
View this thread: http://www.excelforum.com/showthread.php?threadid=39616