i'm looking for some help with this vba function. I want to make a lookup function that compares the value in a searchfield to the value of a range and returns a partial match.
for example, if I have a range that contains the word october it would return that word if I search for oct
The function I have works. However it is pretty slow when applied to large ranges. I've converted all my ranges to arrays and used those to search. I think solving the function without arrays should speed it up considerably.
can anyone help me with the following two problems:
* How can I change this function to work without having to convert my ranges to arrays first
* How do I get this function to work with an entire column
Bookmarks