Issue with variable

[LarsJ]

It's not the Switch line that fails. It's the Case lines that fails. In a Switch statement you can only use literal values in the Case lines. From the Help file:

Case <value> [To <value>] [,<value> [To <value>] ...]

You cannot use expressions eg. string functions on the Case values in a Switch statement. StringInStr() will not work.

 

You can use expressions on the Case values in a Select statement. From the Help file:

Case <expression1>

StringInStr() works in a Select statement.

And you can use expressions in If statements.

[shornw]

Well identified  - thank you for this information which has finally clarified the behaviour I was seeing