| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting a macro resulted in a problem | Excel Discussion (Misc queries) | |||
| deleting a macro resulted in a problem | Excel Discussion (Misc queries) | |||
| Hotkey problem w/ macro to append comment | Excel Discussion (Misc queries) | |||
| Macro problem | New Users to Excel | |||
| Circular Problem needs Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
