Character checking problem in an if statement

[KeithMale]

Hi all,
I am trying to change a variable depending on a character in a string (it should be different if the character is a V, W or L). Right now the code doesn't seem to get into the second If statement and I am not sure why, because it should go to the ElseIf statement to check that condition. None of the conditions are being met.
Is there a problem with my method of checking if the variable is a certain character?
Please let me know if there is method to do this, or a fix to my code to get it working.

Please Login or Register  to view this content.

I tried

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

also, but neither seems to work.

[HaHoBe]

Hi, KeithMale,

amybe use a Select case:

Please Login or Register  to view this content.

Ciao,
Holger

[AB33]

You have one if and with else if statement.
The code first checks this line: If it is true, it jumps to the end of it.

If IsNumeric(J) Then

It is false, it goes to

ElseIf J = LetterV Then
If this true, you have further nested loop. It is false, it goes to the bottom of if end

[KeithMale]

I didn't think of the select case, Thanks HaHoBe!
You are right AB33, it was jumping to the end because none of the conditions were being met. Guess I should be more specific in my description of the problem.

[AB33]

If it is returning false, you need to check this line

Please Login or Register  to view this content.

Step over using F8 (Using local window)and see what value do you get when the code hits that line.

[KeithMale]

I changed it to the Select Case instead of an If Else, so there is no longer a problem.

That F8 tip is very nice though. Thanks