Thanks. But they are still implemented as functions. So they somehow
manage to modify the sheet from within a function or at least kick off the
update. As I said in the original post I have attempted creating another
thread and letting the function return the first bit of data, and then the
thread was going to dump the rest of the data in. But from what I could see
the sheet was locked even after the function was returned.

Anyone else have any ideas of how to do this or how to write a DDE like
thing to do the populating.

Cheers
Paul


"OJ" wrote in message
oups.com...
Hi,
A UDF cannot make changes to the worksheet, only return values to the
cell(s) in which it is entered. The bloomberg functions you are talking
about (BLP,BLPH) use a DDE server and a couple of C DLL's to 'populate'
the worksheet via an VBA Excel addin.

Hth,
OJ