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

**welchs101** · 07-18-2011, 07:21 AM

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** · 07-18-2011, 07:32 AM

Have you tried searching by row rather than columns:

Please Login or Register  to view this content.

**welchs101** · 07-21-2011, 07:35 AM

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.