View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Quotation marks within a formula

=BLPH(A1,B2,"28/2/2001","17/4/2007",0,FALSE,"D","N","
",TRUE,1600,2,FALSE,"P"," "," ")

I am trying to get a macro to input this formula in cell A1.
I've used the following line of code:

Range("A1").Formula=
"=BLPH(A1,B2,"28/02/2001","17/04/2007",0,FALSE,"D","N","
",TRUE,1600,2,FALSE,"P"," "," ")"

Unfortunately the editor does not allow this to be input as a line of code I
get an error message saying Compile error. Expected :End of statement. I'm
sure that it has to do with the quotation marks within the formula. What is
the correct syntax for this please.
Thank you