Now Function suddenly produces error... help!

[Oliver Dewar]

Hi All.

I have macros with this line of code:

Application.Wait now + TimeValue("00:00:01")

the macros have been working perfectly for months and then suddenly I get the word 'now' highlighted and this error in vba:

Compile Error:
Expected function or variable.

What's happened and how can I fix it?

Thanks in advance.

----> extra thought:

I created a sub called "protect" and vba told me it was an ambigous name... could I have inadvertently created a sub that's the same as a system function and mixed things up, or switched off excels functions or something? (Hopefully it's simpler than that!)

 

[Richard Schollar]

In the VBE if you go Tools>References, do you see anything listed as MISSING? If so, uncheck these and try running again.

 

[Oliver Dewar]

Thanks for your reply... I just got it! I almost hit the nail on the head in my question... and then your answer helped.

I created a sub called 'now'! Just a testing sub... but that's what did it.

Cheers!