When I run a macro it stops at the following point :

ActiveCell.FormulaR1C1 = _
"=ISNA(MATCH(ControlCentre!RC3,Purchases!R24C65:R2 000C65,0))L""""
INDEX(Purchases!R24C[17]:R2000C[17],MATCH(ControlCentre!RC3,Purchases!R24C65
:R2000C65,0))=""UpdateCC""
INDEX(Purchases!R24C42:R2000C42,MATCH(ControlCentr e!RC3,Purchases!R24C65:R20
00C65,0))?"""" "

Here is the leading and ending portion of the macro:

Range("H77").Select
ActiveCell.FormulaR1C1 = _
"=ISNA(MATCH(ControlCentre!RC3,Purchases!R24C65:R2 000C65,0))L""""
INDEX(Purchases!R24C[17]:R2000C[17],MATCH(ControlCentre!RC3,Purchases!R24C65
:R2000C65,0))=""UpdateCC""
INDEX(Purchases!R24C42:R2000C42,MATCH(ControlCentr e!RC3,Purchases!R24C65:R20
00C65,0))?"""" "
Range("H77").Select
Selection.AutoFill Destination:=Range("H77:H1000"), Type:=xlFillDefault

Anyone know why it is not working?
Pat