Posted to microsoft.public.excel.programming

L. Howard

external usenet poster

Posts: 852

Using Find as lookup method goes to semi endless loop

On Sunday, June 22, 2014 4:19:00 AM UTC-7, Claus Busch wrote:
Hi Howard,

Am Sun, 22 Jun 2014 03:53:03 -0700 (PDT) schrieb L. Howard:

I just so happened I had dispersed some sample test strings on the sheet all of which are with in the range od D4:H22.

then set your range and the start cell explicit:

Thar works fine.
You are a champion! Nice and thanks.

Regards,
Howard

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find Method vs. For...Next Loop	mikelee101[_2_]	Excel Programming	3	July 10th 08 09:43 PM
Find Method in For Loop	Sisilla[_2_]	Excel Programming	3	May 3rd 07 08:02 PM
Endless loop	freddie mac	Excel Programming	2	August 1st 06 03:19 PM
endless loop help	John	Excel Programming	1	October 26th 05 04:51 PM
Endless loop?	John	Excel Programming	24	August 2nd 05 06:41 PM

All times are GMT +1. The time now is 11:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us