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