Why is this line erroring?

[crabby09]

Hi Guys,

I am asking VBA to repopulate certain formulae using FormulaR1C1.

"SageSummary" is a defined worksheet

This code populates correctly:

Please Login or Register  to view this content.

And was produced from this original working excel formula:

Please Login or Register  to view this content.

This code produces a 1004 object error:

Please Login or Register  to view this content.

And was produced from this original excel formula:

Please Login or Register  to view this content.

I can't see an issue with the code??

Thanks for any help!

crabby

[Andy Pope]

Check the second version where the YEAR function has an incorrect bracket.

YEAR(R6C[-3))

[crabby09]

Thank you!

Knew it was a simple one, just needed some fresh eyes.

crabby