Posted to microsoft.public.excel.programming

[email protected] marston.gould@alaskaair.com is offline

external usenet poster

Posts: 102

Still Having Application.Match trouble

It turns out that the problem wasn't the routine at all, rather it was
the fact that my array was more than 5461 elements long (a max in
xl2000 I guess). I've tried to set up an alternatate approach - I'll
post that separately in hopes that someone can help me review - because
its still taking more than 8 hrs to run....

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
Trouble with Index & Match	Arturo	Excel Worksheet Functions	3	June 19th 07 04:18 PM
Having trouble with vlookup and match	ADiscrete1	Excel Worksheet Functions	8	November 17th 05 02:09 AM
Still Having Application.Match trouble	[email protected]	Excel Programming	2	September 2nd 04 09:43 AM
Application.Match	[email protected]	Excel Programming	0	September 2nd 04 12:07 AM
Application.Match	[email protected]	Excel Programming	0	September 1st 04 11:06 PM

All times are GMT +1. The time now is 11:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us