To embed quotes inside the string, you must double them, i.e.

[b3] = "blp(""GE Equity"",""Last Price"") Else ....


On Mon, 27 Sep 2004 18:05:57 -0400, susan hayes wrote:

I am trying the following using VBA:

If [b2] = 5 Then [b3] = "blp("GE Equity","Last Price") Else [b3] = ""

in writing this I get a Compile error with GE highlighted, with a
warning reading "Expected: end of statement."

I think its the ". . ." ". . . " quotations inside that are causing
the problem. Is there a way of writing, the following statement:

= blp("GE Equity","Last Price")

so it comes out (appears) in cell B3.

Thank you in advance


Susan