Replacing Formulas with Values

[Raman325]

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

[Tom Ogilvy]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Raman325]

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