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