| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Unable to record macro
When recording a macro an 'Unable to record' message appears when I try to
record a formula. Here is the formula that seems to cause the problem: =IF(ISNA(MATCH(Cont!$C77,Purchases!$BM$24:$BM$2000 ,0)),"",IF(INDEX(Purchases!Y$24:Y$2000,MATCH(Cont! $C77,Purchases!$BM$24:$BM$2000,0))="UpdateCC",INDE X(Purchases!$AP$24:$AP$2000,MATCH(Cont$C77,Purchas es!$BM$24:$BM$2000,0)),"")) Anyone know why this should happen? Thanking you in advance. Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| record an excel macro, save on network so that everyone can access | Excel Discussion (Misc queries) | |||
| How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) | |||
| Record new macro ghosted | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Threaded Mode
