IsMissing Returning False

**Pauleyb** · 03-08-2012, 02:18 PM

Writing a function to shuffle some numbers. This is working:

Please Login or Register  to view this content.

However, I want to define mySeed as an integer, and whenever I change the function declaration to:

Please Login or Register  to view this content.

the IsMissing(mySeed) test is always returning False.

I even copied some code from 'Power Programming in VBA' it is has the same issue. If the parameter is defined, then IsMissing returns False.

Pauley

**rylo** · 03-08-2012, 08:14 PM

Hi

Have a look at the note in this.

rylo

**Pauleyb** · 03-09-2012, 09:44 AM

Hello rylo,
It appears you are correct. Only truly works with Variant types because of the flag. What gets me is I did read the help file for IsMissing, but I guess I read over the 'Note' which details that it does not work with simple data types. Also, the fact that a book that I trust used it incorrectly in an example through me off track.

Pauley