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