Unable to record macro

[Pat]

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

 

[Pat]

Hi PC

Sorry that is a typo error, even with the correction the error message still
appears.

 

[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]

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

 

[PC]

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