VBA - Using Range("A1").Formula = But the formula is over 3 lines so I am using _ at the end, but the IF statement on the next lines are giving errors

Question

Range("A1").Formula = "=IFERROR(If('AUX Table'!A3=""Yes"", IF('Legend'!C1=""Yes"", _ If('Aux colour table'!V1=""Yellow"", etc etc

Either put it all on one line or research how to concatenate strings over multiple lines. Other than for readability, there is no reason to spread over multiple lines anyway. — ACCtionMan, Dec 14 '21 at 11:56

score 1 · Answer 1 · answered Dec 14 '21 at 11:55

1

You need to end the first line with a " then start the new line with the same.

Range("A1").Formula = "=IFERROR(If('AUX Table'!A3=""Yes"", IF('Legend'!C1=""Yes"","_ 
"If('Aux colour table'!V1=""Yellow"""

answered Dec 14 '21 at 11:55

Andreas

1 Answers1