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!


--
excelman
------------------------------------------------------------------------
excelman's Profile: http://www.excelforum.com/member.php...o&userid=26249
View this thread: http://www.excelforum.com/showthread...hreadid=395459

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)

that is exactly what i want to do. works manually...does not work as a
macro since bloomberg doesn't 'generate' the values prior....

i guess is there a code that updates the worksheet before i do the
copy/paste?
i think i'm missing an update code or something...


--
excelman
------------------------------------------------------------------------
excelman's Profile: http://www.excelforum.com/member.php...o&userid=26249
View this thread: http://www.excelforum.com/showthread...hreadid=395459

excelman wrote in
:


that is exactly what i want to do. works manually...does not work as a
macro since bloomberg doesn't 'generate' the values prior....

i guess is there a code that updates the worksheet before i do the
copy/paste?
i think i'm missing an update code or something...



If you do a refresh whilst recording the macro?

Edit/Links etc. . . .


--

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