Thread: Passing a function from VB with text strings in quotation marks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
  
Posts: 390
Default Passing a function from VB with text strings in quotation marks
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!
--
Thanks!
Max
Reply With QuoteReply With Quote