VBA: Invalid procedure call or argument

[carolinauser]

Hello everyone!

I have a file that I use almost everyday, and today when I ran the macro an error appeared " Invalid procedure call or argument" and there is only "Ok" or "Help" to press, there is not Debugger. When I press ok, the selection is on the first line "Sub xxx"

I tried to run all the macros in the file and the same message appears

Has this happened to anyone?? how can I solve it?

 

[RoryA]

Welcome to the forum.

How do you trigger the macros?

 

[Yongle]

Welcome to the forum @carolinauser

Try manually stepping through the simplest macro and you will probably work out what is wrong
- in VBA editor click on macro and keep hitting {F8} until it fails

If this worked correctly before then perhaps the VBA has been changed very recently and a "gremlin" introduced somewhere
- perhaps an incomplete sub or function
- perhaps an argument is not within a valid range etc

The fact that it affects many macros could point to an event macro being triggered and the problem being related to that
Worksheet_SelectionChange??
Worksheet_Change??