Question: what is argument not optional in vba?
Answer: In this article The number and types of arguments must match those expected. Either there is an incorrect number of arguments, or an omitted argument is not optional. An argument can only be omitted from a call to a user-defined procedure if it was declared Optional in the procedure definition.