Continue line within formula

[gyme623]

Hello,

I am using a macro to enter a long if statement formula, and I just can't seem to make the "&_" work to continue to the next line within the formula.

My code is:

ActiveCell.FormulaR1C1 = "=IF(AND(RC[-2]>=0,RC[-2]<100),""GOVT"", IF(AND(RC[-2]>100,RC[-2]<250),""MTGE"", IF(AND(RC[-2]>250,RC[-2]<400),""MUNI"", IF(RC[-2]>400,""CORP""))))"


Any suggestions?

Thanks

 

[Greg Truby]

just break it into sub-strings enclosing each line's string in quotes:

ActiveCell.FormulaR1C1 = "=IF(AND(RC[-2]>=0,RC[-2]<100),""GOVT"", " & _
                         "IF(AND(RC[-2]>100,RC[-2]<250),""MTGE"", " & _
                         "IF(AND(RC[-2]>250,RC[-2]<400),""MUNI"", " & _
                         "IF(RC[-2]>400,""CORP""))))"

In good conscience, I should probably mention that you probably deserve to be chastised for something if you are using activecell. Chances are real good you're doing a SELECT when you needn't. But I cannot convict you based on the evidence presented. :wink: