VBA: IF Formula returning object defined error

[WombleJim]

Morning all,

I have the below code to try and run through a list of start and end dates of an array to return the date after the start date.

Please Login or Register  to view this content.

ws has already been defined as the worksheet earlier in the code and the IF formula if I write it direct onto the worksheet is correct but when I try and add the IF formula into my VBA code it is returning an object defined error.

Any idea where I have gone wrong?

Many Thanks in advance
WombleJim

[mehmetcik]

I always use the macro recorder to record my formulas. I then modify them as needed.

ws.Range("E2:E" & NextRow + 1).FormulaR1C1 = "=IF((RC[-2]-1)>RC[-3],RC[-3]+1,"""")"

[WombleJim]

Thank you mehmetcik, That works like a charm.

Thanks again
Womblejim