|
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 |
Hi PC
Sorry that is a typo error, even with the correction the error message still appears. "PC" wrote in message ... I get an error in the formula in the last MATCH you have "Cont$C77" it should be Cont!$C77 Possibly that is the problem HTH PC "Pat" wrote in message ... 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",INDEX( Purchases!$AP$24:$AP$2000,MATCH(Cont$C77,Purchases !$BM$24:$BM$2000,0)),"")) Anyone know why this should happen? Thanking you in advance. Pat |
I am pleased to say that the solution to the problem turns out to be a
security issue. The workbook is password protected, remove the protection and the macro will record. Thanks for your help nevertheless. Pat "PC" wrote in message ... Unfortunately I can't be much help to you Pat. It worked fine when I c&p'd the formula while using the recorder and it worked when I tried a test run. Sorry PC "Pat" wrote in message ... Hi PC Sorry that is a typo error, even with the correction the error message still appears. "PC" wrote in message ... I get an error in the formula in the last MATCH you have "Cont$C77" it should be Cont!$C77 Possibly that is the problem HTH PC "Pat" wrote in message ... 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",INDEX( Purchases!$AP$24:$AP$2000,MATCH(Cont$C77,Purchases !$BM$24:$BM$2000,0)),"")) Anyone know why this should happen? Thanking you in advance. Pat |
I get an error in the formula
in the last MATCH you have "Cont$C77" it should be Cont!$C77 Possibly that is the problem HTH PC "Pat" wrote in message ... 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",INDEX( Purchases!$AP$24:$AP$2000,MATCH(Cont$C77,Purchases !$BM$24:$BM$2000,0)),"")) Anyone know why this should happen? Thanking you in advance. Pat |
Unfortunately I can't be much help to you Pat. It worked fine when I c&p'd
the formula while using the recorder and it worked when I tried a test run. Sorry PC "Pat" wrote in message ... Hi PC Sorry that is a typo error, even with the correction the error message still appears. "PC" wrote in message ... I get an error in the formula in the last MATCH you have "Cont$C77" it should be Cont!$C77 Possibly that is the problem HTH PC "Pat" wrote in message ... 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",INDEX( Purchases!$AP$24:$AP$2000,MATCH(Cont$C77,Purchases !$BM$24:$BM$2000,0)),"")) Anyone know why this should happen? Thanking you in advance. Pat |
| All times are GMT +1. The time now is 08:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com