Thanks Guys,

So basically I can replace the relative method like for like what I have put in the cell?

so replace
Code:
ActiveCell.FormulaR1C1 = "=COUNTIF((R[-4]C[6]:R[999993]C[6]),""Void"")"
with
=COUNTIF((G2:G999999),"Void")
I have realised I can get rid of the G999999 just by replacing it with G:G to highlight the entire column...