Help with Long formula in VBA in one line

[NeelsBorstlap]

Hi - Need help with this long formula in my code - How (where) do I enter a " _" and then hit enter to keep the code nice under each other and not in 'n long line????

I tried everything but VBA give me a " Compile error: Expected: list separator or )" and I do not know what it means.

ActiveCell.FormulaR1C1 = _
"=IF(ISNUMBER(SEARCH(""loan"",RC[-2])), ""Cash Loan"" , IF(ISNUMBER(SEARCH(""Proleen Balance"",RC[-2])), ""Cash from Proloan"" , IF(ISNUMBER(SEARCH(""cash receipt -client"",RC[-2])), ""Cash Payment"",IF(ISNUMBER(SEARCH(""337"",RC[-5])), ""Exp Fuel Generator"",IF(ISNUMBER(SEARCH(""331"",RC[-5])), ""Exp Printing and Stationary"",IF(ISNUMBER(SEARCH(""332"",RC[-5])), ""Exp Refund CL Proloan"",IF(ISNUMBER(SEARCH(""333"",RC[-5])), ""Exp Groceries"", """")))))))"

Thanks.

Neels

 

[aRandomHelper]

    ActiveCell.FormulaR1C1 = _
        "=IF(ISNUMBER(SEARCH(""loan"",RC[-2])), ""Cash Loan"" , " & _
        "IF(ISNUMBER(SEARCH(""Proleen Balance"",RC[-2])), ""Cash from Proloan"" , " & _
        "IF(ISNUMBER(SEARCH(""cash receipt -client"",RC[-2])), ""Cash Payment""," & _
        "IF(ISNUMBER(SEARCH(""337"",RC[-5])), ""Exp Fuel Generator""," & _
        "IF(ISNUMBER(SEARCH(""331"",RC[-5])), ""Exp Printing and Stationary""," & _
        "IF(ISNUMBER(SEARCH(""332"",RC[-5])), ""Exp Refund CL Proloan""," & _
        "IF(ISNUMBER(SEARCH(""333"",RC[-5])), ""Exp Groceries"", """")))))))"