Passing a function from VB with text strings in quotation marks

[Guest]

Hi,

I'm trying to pass this function to a cell within VB:

=IF(ISERR(VLOOKUP(U2,'Anderson List'!$A$3:$F$1945,1))=TRUE,\" \ MISSING \
"\,IF(VLOOKUP(U2,'Anderson List'!$A$3:$F$1945,1)=U2,\" \ OK \
"\,VLOOKUP(U2,'Anderson List'!$A$3:$F$1945,1)))

but with the quotation marks foul things up. How do I pass the quotes?

Thanks!

 

[Executor]

Hi Max,

Repalce \"\ with ""

e.g.

Range("A1").Formula="=If(TRUE,""First"",""Second"")"


Hoop This Helps,


Executor

 

[Bob Phillips]

double up on them, but only the double-quotes.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Now I get a runtime error 1004 - hmmm... Any other ideas?

 

[Guest]

Nevermind - I figured it out why! Sometimes you just need to step back a
bit. Thanks for the help!