Runtime error '1004': method range of object_global failed

[Kmiller0515]

New to making macros. Keep getting this error and not sure why.


Sub

activessheet.select
range("o3").select
activecell.formulaR1C1 = "=countif(c[-11],""i28"")"
range("O4")'select

end sub

any help would be great!

 

[L. Howard]

Maybe something like this.

Howard

Sub stuff()
 Range("A3").FormulaR1C1 = "=countif(c[-11],""i28"")"
End Sub