View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ALVESM ALVESM is offline
external usenet poster
 
Posts: 6
Default assign formula to a cell

blp is a function that uses third party software via ddl links. the software
in question is bloomberg which is a market data feeder.

i think the previous post sorted it out.

cheers

"FSt1" wrote:

hi.
not sure. =blp does not look like a standard excel function suggesting that
it might be a user defined function. post the UDF.

lunch.
Regards
FSt1

"ALVESM" wrote:

hi. i want to do this:
Worksheets("sheet1").Range("init").Offset(1, -1) = "=blp("SPX Index","last
price")"
but i cant because excel assumes the formula terminates on the second ",
therefore assuming the formula is =blp(

can you help me out?