Instr Function

[voodoo]

Im trying to use the Instr function to check wheteher a cell contains either of 2 values "GBP" or "GBR". Below is my code which I thought was correct but even when I am 100% sure the cell contains one of these values and I checked Length of value and it is 3, still I am getting False.

If InStr(.Cells(1, intStartRow, cVWAP_CURR_COL).Value, "GBR") = True Or _
InStr(.Cells(1, intStartRow, cVWAP_CURR_COL).Value, "GBP") = True Then

pboolBritain_GBP = True

End If

I am puzzled as to what is wrong because I have used Instr before and never had this problem.

Can anyone see anything wrong with this code or any ideas where I may be going wrong.

Thanks for any help

 

[voodoo]

Answered my own question. I should not use True or False. Also I ahd a misplaced 1 in that previous code. This worked

If InStr(.Cells(intStartRow, cVWAP_CURR_COL).Value, "GBR") Or _
InStr(.Cells(intStartRow, cVWAP_CURR_COL).Value, "GBP") Then

pboolBritain_GBP = True

End If

Silly me

 

[Gates Is Antichrist]

Just a personal note - thanks for taking the trouble to give the followup even though you didn't need to. Too often it seems that question-posters never share new knowledge when they don't get a quick answer from the group.

From time to time I look up a question in Google and I hit on someone who describes exactly - I mean EXACTLY! - the same problem as I have. I gleefully click the link, and find a sad orphan question with nary a blink in its direction. (Disclaimer: except for MrExcel threads, ROFL)