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)