I have a sheet that uses links to get its data. I would like to remov
the links once the data has been updated through a macro. The easies
way I can think of is to copy the cell then paste it back into itself
but that would be inefficent and slow. Is there an easier/better way t
do this? Thank you in advance

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

Hi Raman325

You can also use the value property
See
http://www.rondebruin.nl/values.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Raman325" wrote in message
...

I have a sheet that uses links to get its data. I would like to remove
the links once the data has been updated through a macro. The easiest
way I can think of is to copy the cell then paste it back into itself,
but that would be inefficent and slow. Is there an easier/better way to
do this? Thank you in advance.


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

Check out:

http://office.microsoft.com/en-us/as...656061033.aspx

Good Luck
--
Gary's Student


"Raman325" wrote:


I have a sheet that uses links to get its data. I would like to remove
the links once the data has been updated through a macro. The easiest
way I can think of is to copy the cell then paste it back into itself,
but that would be inefficent and slow. Is there an easier/better way to
do this? Thank you in advance.


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