So, I have a function created to check an array for matching values. The problem I'm having is that the function is finding a match for approximate values. For example, if I choose "Josh" and the values I'm checking against include just that text imbedded within them (ex. "Josheroni"), it's finding "Josheroni" as well as "Josh." I am trying to find a way to amend my existing code to only match exact values. Please help if you can. Code is below:
Please Login or Register to view this content.
Last edited by Rokn; 03-14-2019 at 11:08 AM. Reason: Code is slightly incorrect
If the Ubound is > -1 then . you need to loop through the array and test each item, exiting if you find it.
Everyone who confuses correlation and causation ends up dead.
No need for the function, you can do it likePlease Login or Register to view this content.
You could also do:
Though I'd loop, though not with a For Each, you're better looping through arrays by indexPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks