Stuck on IF statement

[srosk]

I'm having trouble with the following code. Hopefully someone is able to help.

If Sheets("Instructions").Range("D20").Value = "Yes" And Range("E" & r).Value = 6 And Range("AK" & r).Value = 1 Then
        VestingReport2Import_4Message 3, False, r, "_", "_", "Test Message"

If Instruction D20 = Yes and the value in column in E = 6 and AK = 1, then it should put "Test Message". The program works when And Range("AK" & r).Value = "1" is commented out.

Is there any way for the additional criteria to be added? Currently, it is as if all of column AK <> 1, because nobody received the test message.

Thank you!

 

[Special-K99]

Rounding error ? What makes you think "AK & r" is 1 ?
Put the cursor in each cell that you think is 1 in AK and have a close look at the value just above columns D and E (on the right of the"fx"), that will tell you the true cell value. It might say 1 in the cell but it may be a different value above.

 

[srosk]

Rounding error ? What makes you think "AK & r" is 1 ?
Put the cursor in each cell that you think is 1 in AK and have a close look at the value just above columns D and E (on the right of the"fx"), that will tell you the true cell value. It might say 1 in the cell but it may be a different value above.

Hey there thanks for the reply. Earlier in my program it is set to define AK to equal a 1 or 0 using an IF and Vlookup statement. I then copy paste value to AK, and then run VestingReport2Import_4Message