"Excel should recognize that if you're going from 10 to 1
it's going "down"! "... yeah.. that would be nice, but it doesn't)
good luck!
Paul
>
>From: Dave Bonallack
>To: "excel-macros@googlegroups.com"
>Sent: Fri, October 1, 2010 10:00:46
0 05:15:54 -0700
> From: schreiner_p...@att.net
> Subject: Re: $$Excel-Macros$$ Macro hangs
> To: excel-macros@googlegroups.com
>
> Dave, keep in mind that Excel can do several HUNDRED comparisons each SECOND.
>
> If you're adding an Application.wait for only ONE second EACH
the index, and update the values
with
the array of rows
for that index:
for example, the dictionary is by "originator".
the value is:
dict_orig.item(schreiner) = 100|105|310|416|500
then, when I want to report by originator, I read the dictionary, split the
value into an array
and loo
) then I will
definitely be impressed, and dictionaries may even rise above SumProduct (in my
eyes).
Regards - Dave.
> Date: Wed, 29 Sep 2010 05:15:54 -0700
> From: schreiner_p...@att.net
> Subject: Re: $$Excel-Macros$$ Macro hangs
> To: excel-macros@googlegroups.com
>
> D
Dear Friend,
How much time did it take to get the result?
Regards,
Angelo
2010/9/29 ashish koul
> hi
>
> check the attchment see it it helps you
>
> you can apply the filter and delte all rows with "d" and then remove the
> temp column
>
>
>
>
>
>
> On Wed, Sep 29, 2010 at 2:44 PM, Dave Bonall
Dave, keep in mind that Excel can do several HUNDRED comparisons each SECOND.
If you're adding an Application.wait for only ONE second EACH LINE for 13,000
lines,
you're adding 13,000 SECONDS, or 216 minutes, or 3.6 hours of WAIT TIME!
so, I suspect that you're not "hanging", but simply waiting