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