This formula works in the cell but I need it in VBA and it doesn't want to
play!

The formula is in cell J4
=IF(I4=(VLOOKUP(K4,'E:\MANMON\TEAMS VALIDATION\Teams
Master\[TEAMS_Master.xls]Officers'!$A$2:$C$40,3,FALSE)),"","88888888")

I have tried this:
ActiveCell.FormulaR1C1 = "=IF(RC[-1]="(VLOOKUP(RC[+1],'E:\MANMON\TEAMS
VALIDATION\Teams
Master\[TEAMS_Master.xls]Officers'!$A$2:$C$40,3,FALSE)","""",88888888))"

Is it just a formatting thing?
--
Regards, Dean