excelman wrote in
:


I am trying to create a macro that 'copies' a cell (that feeds off a
Bloomberg link) in one worksheet and 'paste' into another worksheet. I
don't need the link explicitly pasted but just need the value. Does
anyone know how to do this? Much thanks!


Record the macro while doing a copy and paste special/value?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)