| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax Problem with formula code
Hey guys below is a line of code in my project. In the
VBE it is showing up in red because it does not like the "" within the formula. I know the format to enter the formula in the cell is correct because I have used the same format on other occasions. Its just so many of the "" is messing it up. How do I correct this? ActiveCell.FormulaR1C1 = "=IF(AND(B6<"",E6<"")=TRUE,IF (B6="",,) & IF(B6<"",B6&" - 1YR",) & IF(E6="",,) & IF (E6<"","; "&E6&" - 2YR",),IF(B6="",,) & IF(B6<"",B6&" - 1YR",) & IF(E6="",,) & IF(E6<"",E6&" - 2YR",))" Thank you Todd Huttenstine |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax problem with code | Excel Discussion (Misc queries) | |||
| VBA code to sum a row: syntax needed | Excel Discussion (Misc queries) | |||
| syntax question - cell references in VB code | New Users to Excel | |||
| help with code/syntax | Excel Programming | |||
| Change hard code to Variable syntax | Excel Programming | |||
Threaded Mode
