Excel VBA运行时错误1004：应用程序定义或对象定义错误

I've scoured the internet for an answer to my problem. I am writing some code to input a formula into certain cells on a worksheet and despite very similar code working perfectly earlier in the macro, this section of code will not work with giving me the runtime error 1004: application-defined or object-defined error.I've scoured the internet for an answer to my p