missing and how to test for it

[Chrissirhc]

Hi,

If you don't pass an optional argument to a subroutine it comes up as missing. However, if I try the following code

if myArgument is missing I get a debug error. How do I test for this without trying and catching?

Thanks,

Chris

 

[TonyJollans]

Hi Chris,

Try IsMissing(myArgument) - but it only works for variants - typed arguments are initialised automatically.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[SkipVought]

Chris,

Your variable is proabaly a VARIANT. Use the IsMissing function

...
if ismissing(your_arg) then
...

Skip,

_[red][/red]

 

[Chrissirhc]

it is ismissing(variablename)....