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
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
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" <Raman325.1tv9ut_1124212479.1579@excelforum-nospam.com> wrote in
message news:Raman325.1tv9ut_1124212479.1579@excelforum-nospam.com...
>
> 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
>
Thanks. I tried doing that before and it wasn't working. Maybe I'm doing something else wrong.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks