VBA compile error

[jakobt]

Get an error message: compile error: method or data member not found at each of the two lines starting with selection

Sub Accrual_Provision()
Sheets("backing").Activate
ActiveCell.FormulaR1C1 = "Accrual October"
ActiveCell.FormulaR1C1 = "=+R[-8]C[-1]/9*10"
Range("F41").Select
Selection.NumberFormat = "#,##0.00"
Range("E41").Select
Selection.Font.Bold = True
Range("E41:F41").Select

end sub

 

[Trevor G]

when you created this code did you record via a macro using use relative reference method?

Sub Accrual_Provision()
Sheets("backing").Activate
'What cell is adding "Accrual October"?
'What cell are you using for the formula?
Range("F41").NumberFormat = "#,##0.00"
Range("E41").Font.Bold = True
End Sub