problem with optional parameter

[benjamin.weizmann]

hi,

I made this function:

Public Function blokingmain(Optional indexm As Integer)
 
  If IsMissing(indexm) Then....
 
....

and I call this function:

call blokingmain

but it doesn't make indexm missing
it assigns 0 to indexm

why?
how can I avoid it?


thanks
Ben

 

[JHB]

The link shows how to overcome that, see the notes under Optional Arguments
http://allenbrowne.com/ser-30.html

 

[benjamin.weizmann]

thanks!
I changed it to Variant for all optional
but i'm afraid... if it's a Variant , can it deal with dates well???

Ben