problem doing string equality check in if stmt

[Byron Tate]

I need to have the value of a NamedRange be a string, and use the NamedRange key in an if stmt like this:
engine.AddNamedRange("Y","B12");
engine.AddNamedRange("X","if(D0=Y,A0+B0,(A0))");

But this D0=Y evals to false.

Following works:

engine.AddNamedRange("X","if(D0=\"B12\",A0+B0,(A0))");

So this looks like a bug.

[Administrator]

>>engine.AddNamedRange("Y","B12");

This makes the namedrange Y refer to the cell B12. If you want the namedrange Y to refer to the string B12, then try:

engine.AddNamedRange("Y","\"B12\"");

[Byron Tate]

thanks! quick help as usual.