Excel 2007 : Run Time Error 1004 when inserting formula

I am trying to add cell formulas using VBA. When the code runs I get a 'Run Time Error 1004' application defined or object defined error. The error occurs where it is inserting the formulas into the cell. I have commented out the first one or two and still get the error. These formulas work when entered in the spreadsheet. The code I am using is below

Please Login or Register  to view this content.