View Single Post
  #4   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 mark

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


--
Thanks!
Max


"Executor" wrote:

Hi Max,

Repalce \"\ with ""

e.g.

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


Hoop This Helps,


Executor