problems passing a null value as part of a function...

[Brad Pears]

I have a function that sometimes may have to pass a null value as one of
it's parameters. However, as soon as the parameter being passed happens to
be null, the code runs the "on error" routine...

I want the value to sometimes be null, and the called function handles it
there...

How do you perform a function that may include a null value for one of it's
parameters?

Thanks, Brad

 

[Guest]

Declare the argument in the function as Variant data type.

 

[Brad Pears]

Perfect! Thanks for that - didn't even think of that!

Brad