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",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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

Hi PC

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


"PC" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> Hi PC
>
> Sorry that is a typo error, even with the correction the error message
still
> appears.
>
>
> "PC" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > Hi PC
> >
> > Sorry that is a typo error, even with the correction the error message
> still
> > appears.
> >
> >
> > "PC" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>