Hi
Keep in mind: Recording a macro is a feature very helpful to get an idea what is required or to figure out methods, properties, ... whatsoever. But the recording also records all your selections you did, and at least that part you have to transform to another syntax.
Now I don't know your macro, but whatever you want the macro to perform you have to address explicity where it should be performed. The right thing would be, to enter a formula in Sheet2:
Code:
Sub EnterAFormula()
ThisWorkbook.Sheets("Sheet2").Range("C3").Formula = "=A1"
End Sub
Though it's not necessary to address "Thisworkbook" if your "Sheet2" is within the active workbook. The same applies to the address "Sheets("Sheet2"), if the Range is within the active sheet.
So probably by now you know what to change in your macro. If not, just post your code, and I will show it on your example.