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