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?

Worksheets("sheet1").Range("init").Offset(1, -1) = "=blp(""SPX
Index"",""last price"")"

Regards

Trevor


"ALVESM" <(E-Mail Removed)> wrote in message
news5849C2C-CAF8-42B3-AF4C-(E-Mail Removed)...
> 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?

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?

> .....Offset(1, -1) = "=blp("SPX Index","last > price")"

In a String constant (delineated by quote marks surrounding it), internal
quote marks must be doubled up. So, your code should look like this...

......Offset(1, -1) = "=blp(""SPX Index"",""last > price"")"

That is the rule for all String constants, not just for the way you used it
here.

Rick

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?