Hello,
I have a problem, I'm using vba to look for a text string in column A, but the text string I'm looking for is greater than 255 characters.
I need a workaround. I think I have an idea of what I want to do, I just don't know how to do it.
I think I'd like to search for the first 255 characters (left(Combination, 255)) of my string. If I find the first 255 characters of a string in a cell, then search that specific cell to see if the last 255 characters (right(Combination, 255)) are present. If so, do something
This is what I worked up so far, but it fails on the second find. Any help would be much appreciated. Thanks!
Bookmarks