How to Split VBA code in New lines

[naveenmarapaka]

Hi all,
i am finding difficulty to split the VBA code to new lines.
getting error always as i tried many ways with _ , VBLF etc

pls help to solve it

 .FormulaR1C1 = "=IF(OR(RC[4]=497,RC[4]=10403),""UAE COURT PROJECT"",IF(RC[4]=825,""SHJ MUNICIPALITY"",IF(OR(RC[14]=""Kalyan"",RC[14]=""Kandaj"",RC[14]=""loreleen"",RC[14]=""nabeeh"",RC[14]=""AbelAP"",RC[14]=""Kalyana Chinnak"",RC[14]=""Fathelrahman"",RC[14]=""John Bosco"",RC[14]=""Nilantha Jayaso"",RC[14]=""Nilantha"",RC[14]=""Abel Apostol"",RC[14]=""SunilR"",RC[14]=""kumarapelie"",RC[14]=""AhmedEla"",RC[14]=""HafizAl"",RC[14]=""Abdulbasit"",RC[14]=""Younus"",RC[14]=""MouradC""),""SHJ"",IF(OR(RC[14]=""sadanandan"",RC[14]=""Sadanandan Nedu"",RC[14]=""Jayaprakash"",RC[14]=""ImranI"",RC[14]=""Imran"",RC[14]=""johnb"",RC[14]=""Faroz""),""AQZ"",IF(OR(RC[14]=""Ermin"",RC[14]=""Amina""),""DIC"",IF(OR(RC[14]=""Imrank"",RC[14]=""Rashidmahmood"",RC[14]=""buhari"",RC[14]=""HusamA"",RC[14]=""Hajam"",RC[14]=""AMashrafK"",RC[14]=""rashidmahmoodM"",RC[14]=""Atif"",RC[14]=""Bazlulhuk""),""AAN"",IF(OR(RC[14]=""AwliyaA"",RC[14]=""jabarullah"",RC[14]=""Nasr Ahmed"",RC[14]=""ZainabS""),""RKT"",""DXB"")))))))"

[Andy Pope]

        .FormulaR1C1 = "=IF(OR(RC[4]=497,RC[4]=10403),""UAE COURT PROJECT""," & _
                       "IF(RC[4]=825,""SHJ MUNICIPALITY"",IF(OR(RC[14]=""Kalyan"",RC[14]=""Kandaj""," & _
                       "RC[14]=""loreleen"",RC[14]=""nabeeh"",RC[14]=""AbelAP"",RC[14]=""Kalyana Chinnak""," & _
                       "RC[14]=""Fathelrahman"",RC[14]=""John Bosco"",RC[14]=""Nilantha Jayaso""," & _
                       "RC[14]=""Nilantha"",RC[14]=""Abel Apostol"",RC[14]=""SunilR"",RC[14]=""kumarapelie""," & _
                       "RC[14]=""AhmedEla"",RC[14]=""HafizAl"",RC[14]=""Abdulbasit"",RC[14]=""Younus""," & _
                       "RC[14]=""MouradC""),""SHJ"",IF(OR(RC[14]=""sadanandan"",RC[14]=""Sadanandan Nedu""," & _
                       "RC[14]=""Jayaprakash"",RC[14]=""ImranI"",RC[14]=""Imran"",RC[14]=""johnb"",RC[14]=""Faroz"")," & _
                       """AQZ"",IF(OR(RC[14]=""Ermin"",RC[14]=""Amina""),""DIC"",IF(OR(RC[14]=""Imrank""," & _
                       "RC[14]=""Rashidmahmood"",RC[14]=""buhari"",RC[14]=""HusamA"",RC[14]=""Hajam""," & _
                       "RC[14]=""AMashrafK"",RC[14]=""rashidmahmoodM"",RC[14]=""Atif"",RC[14]=""Bazlulhuk"")," & _
                       """AAN"",IF(OR(RC[14]=""AwliyaA"",RC[14]=""jabarullah"",RC[14]=""Nasr Ahmed""," & _
                       "RC[14]=""ZainabS""),""RKT"",""DXB"")))))))"

[ianxwood]

Hi

Since the total formula is 1 string you`ll need to close it at each line break and then concatenate and reopen the string on the next line E.G.

         .FormulaR1C1 = "=IF(OR(RC[4]=497,RC[4]=10403),""UAE COURT PROJECT"", " & _
        "IF(RC[4]=825,""SHJ MUNICIPALITY"",IF(OR(RC[14]=""Kalyan"",RC[14]=""Kandaj"", " & _
        "RC[14]=""loreleen"",RC[14]=""nabeeh"",RC[14]=""AbelAP"",RC[14]=""Kalyana Chinnak"", " & _
        "RC[14]=""Fathelrahman"",RC[14]=""John Bosco"",RC[14]=""Nilantha Jayaso"",RC[14]=""Nilantha"", " & _
        "RC[14]=""Abel Apostol"",RC[14]=""SunilR"",RC[14]=""kumarapelie"",RC[14]=""AhmedEla"",RC[14]=""HafizAl"", " & _
        "RC[14]=""Abdulbasit"",RC[14]=""Younus"",RC[14]=""MouradC""),""SHJ"",IF(OR(RC[14]=""sadanandan"", " & _
        "RC[14]=""Sadanandan Nedu"",RC[14]=""Jayaprakash"",RC[14]=""ImranI"",RC[14]=""Imran"",RC[14]=""johnb"", " & _
        "RC[14]=""Faroz""),""AQZ"",IF(OR(RC[14]=""Ermin"",RC[14]=""Amina""),""DIC"",IF(OR(RC[14]=""Imrank"", " & _
        "RC[14]=""Rashidmahmood"",RC[14]=""buhari"",RC[14]=""HusamA"",RC[14]=""Hajam"",RC[14]=""AMashrafK"", " & _
        "RC[14]=""rashidmahmoodM"",RC[14]=""Atif"",RC[14]=""Bazlulhuk""),""AAN"",IF(OR(RC[14]=""AwliyaA"", " & _
        "RC[14]=""jabarullah"",RC[14]=""Nasr Ahmed"",RC[14]=""ZainabS""),""RKT"",""DXB"")))))))"

Regards
Ian

[naveenmarapaka]

Thanks a million , Its perfectly working.