Posted to microsoft.public.excel.programming

Will[_13_] Will[_13_] is offline

external usenet poster

Posts: 2

Technically, can anyone explain to me why Cells.Find() is so much faster than a loop?

Can someone please explain to me why it is so much faster to use the
built in application functions, particularly for searching, when
programming an Excel Macro than creating a loop? Thanks for your time.

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
For Next loop faster with counter after Next?	RB Smissaert	Excel Programming	22	August 28th 06 05:12 AM
Faster way to loop through two ranges	YH	Excel Programming	5	August 26th 06 05:17 PM
Is there a faster loop than this	Andibevan	Excel Programming	4	August 25th 06 03:27 PM
VBA \| Individual Iterations faster than Loop Statement	Butaambala	Excel Programming	4	July 3rd 05 12:51 PM
Faster For-Next Loop?	[email protected]	Excel Programming	3	January 7th 05 09:08 PM

All times are GMT +1. The time now is 07:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us