Macro running problem
 

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

What is the L"""" in this formula supposed to do? Looks invalid to me!

"Pat" wrote:

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

Here is the formula as recorded, it works fine in the cell(s)

=IF(ISNA(MATCH(ControlCentre!$C77,Purchases!$BM$24 :$BM$2000,0)),"",IF(INDEX(
Purchases!Y$24:Y$2000,MATCH(ControlCentre!$C77,Pur chases!$BM$24:$BM$2000,0))
="UpdateCC",INDEX(Purchases!$AP$24:$AP$2000,MATCH( ControlCentre!$C77,Purchas
es!$BM$24:$BM$2000,0)),""))



"Bob Umlas, Excel MVP" wrote in
message ...
What is the L"""" in this formula supposed to do? Looks invalid to me!

"Pat" wrote:

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