For Exit Loop in instr function

**drcheaud** · 08-17-2011, 04:12 PM

Hi. Trying to speed up a macro that utilizes the instr function. Attached is a sample workbook. Is there a way to exit the loop early to maximize speed in this macro?

Thanks

Sample code:

Please Login or Register  to view this content.

**BigBas** · 08-17-2011, 04:18 PM

Use the .FIND method as opposed to Instr ??

**drcheaud** · 08-21-2011, 02:00 PM

not sure how to implement the find function. can a code be written which will use a range of data as the find criteria and then search a string for the substring?

**snb** · 08-21-2011, 03:24 PM

Please Login or Register  to view this content.

For Exit Loop in instr function

LinkBack

Thread Tools

Rate This Thread

Display

For Exit Loop in instr function

Re: For Exit Loop in instr function

Re: For Exit Loop in instr function

Re: For Exit Loop in instr function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions