Visual Basic for Applications Reference

Argument not optional (Error 449)

See Also    Specifics

The number and types of argument 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 parameterOptional in the definition.

For additional information, select the item in question and press F1.