Using excel "find" takes a long time is there a better approach

[welchs101]

I have the following code where i am searching for the word "study" and "protocol". But the code i use to find these takes a long time. Is there a better way? Can i reduce / combine some of the finds so it does not take as long. If this helps i expect to find these words somewhere in the first 25 rows of data.

Please Login or Register  to view this content.

[romperstomper]

Have you tried searching by row rather than columns:

Please Login or Register  to view this content.

[welchs101]

yeah, i tried that.

What i eventually came up with is this.

Note: the sheet i was searching at like 96000 rows and about 25 cols.

What i was searching for "should be" in the first 25 cols and 35 rows.

So i limited my search to 25cols and 35 rows and ".find" went much much faster.

[romperstomper]

That really shouldn't matter if you search by rows, unless the search value isn't found.