VBA formula help

Hi all   Is someone please able to check the Syntax of this macro. For some reason, it does everything but add the formula in C8 and pull it down to the last cell and I can't figure out why. It jus...