Optional statement

[peter]

I have an IIf statement in a module. I get a compile
error saying I need to make the statement optional. How
do I do this. thankyou for any help. Have a great day
all. Peter.

 

[Dirk Goldgar]

I have an IIf statement in a module. I get a compile
error saying I need to make the statement optional. How
do I do this. thankyou for any help. Have a great day
all. Peter.

That's a new one on me. What is the exact text of the error message?
Use Ctrl+C and Ctrl+V to copy and paste the error message into your
reply, if possible. Also, please copy and paste the statement that is
causing the error.

 

[Marshall Barton]

I have an IIf statement in a module. I get a compile
error saying I need to make the statement optional. How
do I do this. thankyou for any help. Have a great day
all. Peter.

Would you mind posting the code you/'re using?