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.
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.