I am somewhat new to VBA, and I could swear I read something where it said that if I wanted to use the isMissing function against a certain parameter, that parameter had to be declared as variant in the function statement.

Is that true? I thought I read that somewhere, but now I can't find somethign to verify it. Although, by change one of my optional parameters from Range to Variant did solve the error message, so I am leaning towards yes.

If that is the case doesn't that mean you will have to declare all optional parameters variant, since you have to test to see if your parameter was included or not in the function?