Working Formula Entered in Recorded Macro doesn't work when run!

Hello,

I am using the following formula, and it works as intended:

Please Login or Register  to view this content.

However, when I record a macro where I enter the formula...

Please Login or Register  to view this content.

...it doesn't work when I try and run it...

What's the problem, how do I fix it, and how do I avoid it?

Thanks for all help in advance.

That's not it, though. I changed it and it still doesn't work, and my original formula doesn't have a missing P.

Wow, that may the first time in my history on this forum that one your "Maybe:"s didn't work. It threw the application undefined error.

But I like your logic, I will have to play with it.

Thanks, John. I wonder why the macro recorder doesn't just copy it correctly.