Formula in VBA not working

[taostep1]

Hi All,

The following VBA is kicking out a 1004 error and can't seem to understand why this is happening.

Sub test()


Sheets("pivot").Select


Range("F5").Select
ActiveCell.FormulaR1C1 = "=IF(COUNTIF('Confirmed Movement '!$L:$L,RC[-2])>0,""INPUT IS NEEDED"",""NOT ON EDGE ROSTER"")"




End Sub

Any help would be great.

 

[Takae]

Please try it.
Range("F5").FormulaR1C1"=IF(COUNTIF('Confirmed Movement '!C12,RC[-2])>0,""INPUT IS NEEDED"",""NOT ON EDGE ROSTER"")"

 

[taostep1]

But I need the entire range of column L for this formula to legit work. Is there another alternative?

 

[Norie]

C12 is the entire column L, in R1C1 notation.