Need to improve speed of Excel macro that searches for whole word matches
That data is private but I have created a similar database of about 1070 records with the 4 code modules (two for case sensitive and two for case insensitive; the other two are for finding all occurrences and for whole word matches).
The code ran pretty fast on the 1070-record database, so I copied most of it 6 times to increase it to about 6300 records. Results running match whole word, case insensitive on a search for 'the':
searching 1070 records: found 462 in 25 seconds
searching 6319 records: found 2717 in 49 seconds
These were faster times than my original tests but I would still like to know if the searching can be faster, whether using find.next or another method.
Sample database attached.
|