This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
The number and types of
arguments
must match those expected. This error has the following causes and solutions:
Incorrect number of arguments. Supply all necessary arguments. For example, the
Left
function requires two arguments; the first representing the character string being operated on, and the second representing the number of characters to return from the left side of the string. Because neither argument is optional, both must be supplied.
Omitted argument isn't optional. An argument can only be omitted from a call to a user-defined
procedure
if it was declared
Optional
in the procedure declaration. Either supply the argument in the call or declare the
parameter
Optional
in the definition.
For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see
Office VBA support and feedback
for guidance about the ways you can receive support and provide feedback.