Hello,

Would appreciate it if anyone can help me with the below. This code works fine in Excel 2010 but when moved to a different PC with Excel 2007 then it brings up the Runtime Error 1004 Application-defined or object-defined error.

Sub icalculate()
[Table1[Month/Year]].Formula = "=CONCATENATE(MONTH([@[Column1]]),""-"",YEAR([@[Column2]]))"
[Table1[Final Amount]].Formula = "=IF([@[Column3]]=0,[@[Column3]],(0-[@[Column4]]))"
[Table1[Final Cost]].Formula = "=IF([@[Column3]]=0,[@[Column5]],0-[@[Column6]])"
[Table2[Date]].Formula = "=CONCATENATE(DAY([@[Column7]]),""-"",MONTH([@[Column8]]),""-"",YEAR([@[Column9]]))"
[Table2[Final Amount]].Formula = "=IF([@[Column10]]=""order"",[@[Column11]],(0-[@[Column12]]))"
[Table2[Final Margin]].Formula = "=IF([@[Column13]]=""order"",[@[Column14]],0-[@[Column15]])"
End Sub
Can anyone help please?