As Microsoft says, an Invalid Procedure Call Or Argument (Error 5) occurs when you have a specified value that is out of the range of the argument or you are using a procedure that is not available in the current Excel platform. The error could be one of these problems that can cause by different reasons.
For example, you are using a VBA function SIN in the code. Now while specifying the value for the argument you go out of the range of numbers then VBA generates this error.
Or lets you have written a code in the Window version of Excel and when you try to run the same code in the Macintosh version you get the Error 5 Invalid Procedure Call or Argument because the procedure you are trying to run is not valid.
More on VBA Errors
Subscript Out of Range (Error 9) | Type Mismatch (Error 13) | Runtime (Error 1004) | Object Required (Error 424) | Out of Memory (Error 7) | Object Doesn’t Support this Property or Method (Error 438) | Overflow (Error 6) | Automation error (Error 440) | VBA Error 400