Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When do I use quotation marks in an Excel formula? | Excel Worksheet Functions | |||
Literal quotation marks retained from a formula | Excel Discussion (Misc queries) | |||
formula strings containing quotation marks - VBA | Excel Programming | |||
Use quotation marks in a formula to display a qty in feet and inc. | Excel Worksheet Functions | |||
Using quotation marks | Excel Programming |