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.

Attached Files

Sample File for Extract by Row macro.xlsm (276.2 KB, 11 views)