Macro running problem

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

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

ActiveCell.FormulaR1C1 = _
"=ISNA(MATCH(ControlCentre!RC3,Purchases!R24C65:R2000C65,0))L""""
INDEX(Purchases!R24C[17]:R2000C[17],MATCH(ControlCentre!RC3,Purchases!R24C65
:R2000C65,0))=""UpdateCC""
INDEX(Purchases!R24C42:R2000C42,MATCH(ControlCentre!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:R2000C65,0))L""""
INDEX(Purchases!R24C[17]:R2000C[17],MATCH(ControlCentre!RC3,Purchases!R24C65
:R2000C65,0))=""UpdateCC""
INDEX(Purchases!R24C42:R2000C42,MATCH(ControlCentre!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,Purchases!$BM$24:$BM$2000,0))
="UpdateCC",INDEX(Purchases!$AP$24:$AP$2000,MATCH(ControlCentre!$C77,Purchas
es!$BM$24:$BM$2000,0)),""))



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

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

ActiveCell.FormulaR1C1 = _
"=ISNA(MATCH(ControlCentre!RC3,Purchases!R24C65:R2000C65,0))L""""
INDEX(Purchases!R24C[17]:R2000C[17],MATCH(ControlCentre!RC3,Purchases!R24C65
:R2000C65,0))=""UpdateCC""
INDEX(Purchases!R24C42:R2000C42,MATCH(ControlCentre!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:R2000C65,0))L""""
INDEX(Purchases!R24C[17]:R2000C[17],MATCH(ControlCentre!RC3,Purchases!R24C65
:R2000C65,0))=""UpdateCC""
INDEX(Purchases!R24C42:R2000C42,MATCH(ControlCentre!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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to record macro 4
look up formula 4
Macro Crashes 1
Run-time Error '1004' 3
Macro that deletes and pastes filterd rows and then some 2
macro to copy rows that contain a cell with a certain number 2
Macro should Save and Overwrite file 1
Excel Excel Macro Help 2

Back
Top