[SOLVED] Syntax for Writing Long VBA Formula on Multiple Lines

Hi,

I have a large formula I am trying to input that is making me put it on two lines. I cannot get the syntax to work properly and was looking for some assistance. The range and actual formula all work properly, I am just looking for how to break the formula onto multiple lines in VBA.

Range(Cells(4, StartValue), Cells(TimelineRow, TimelineColumn)).Formula = "=IF(ISERROR(VLOOKUP($B4,OFFSET('Future NBV'!$A$3,,,'Macro Workspace'!$S$5,'Macro Workspace'!$S$6),MATCH(C$3,'Future NBV'!$1:$1,0),FALSE)),VLOOKUP($B4,OFFSET('Investment Aircraft'!$H$22,,,'Macro Workspace'!$S$7,'Macro Workspace'!$S$8),MATCH(C$3,'Investment Aircraft'!$21:$21,0)-7,FALSE),IF(ISERROR(VLOOKUP($B4,'Macro Workspace'!$B$5:$K$" & YYY & ",10,FALSE)),VLOOKUP($B4,OFFSET('Future NBV'!$A$3,,,'Macro Workspace'!$S$5,'Macro Workspace'!$S$6),MATCH(C$3,'Future NBV'!$1:$1,0),FALSE),IF(AND(EOMONTH(VLOOKUP($B4,'Macro Workspace'!$B$5:$K$" & YYY & ",10,FALSE),0)>=C$3,VLOOKUP($B4,OFFSET('Future NBV'!$A$3,,,'Macro Workspace'!$S$5,'Macro Workspace'!$S$6),MATCH(C$3,'Future NBV'!$1:$1,0),FALSE)=0),B4-VLOOKUP($B4,'Macro Workspace'!$B$5:$P$" & YYY & ",15,FALSE),IF(AND(C$3>VLOOKUP($B4,'Macro Workspace'!$B$5:$K$" & YYY & ",10,FALSE),VLOOKUP($B4,'Macro Workspace'!$B$5:$L$" & YYY,11,FALSE)="Yes"),0,VLOOKUP($B4,OFFSET('Future NBV'!$A$3,,,'Macro Workspace'!$S$5,'Macro Workspace'!$S$6),MATCH(C$3,'Future NBV'!$1:$1,0),FALSE)))))"

Many thanks in advance for your help!

Regards,
nwd9s

When you break a long formula, you have to catenate the sub strings:

Range("A1").Formula = "=if(this long condition, this expression , " & _
                      "that expression)"

It's much easier to debug if you assign the formula to a string, and print the string to the Immediate window for perusal.