Interesting Error With Instr Function

[RealMccoy13x]

Hello All,

I am having a weird error with "Instr". I have used it many times over, but never used it comparing two arrays against each other. Here is the deal. The two arrays listed below are both string arrays which have been trimmed, and upper cased. What is happening is when I set a breakpoint "LPosition" is never getting set....it is always 0 when in multiple cases it should be otherwise. When I find a case where it is a match I hover over "LPosition" and it is 0, but when I hover over InStr itself it shows that it indeed is working and matched at 1. When I try one that doesn't match I hover over InStr and it shows 0. The problem I am facing is why isn't it passing to the integer value. Any help would be appreciated. Thanks.

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[MrShorty]

I tried it (making up some value for merchname and merchmaster), but I did not readily recreate a scenario where Instr() did not return the correct value. We probably need to know what values are in merchname and merchmaster so that we can see what scenarios are causing the wrong value to be returned to Lposition.

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.