Why dictionary very slow ,is dictionary have maksimum data

**daboho** · 10-30-2018, 02:27 AM

I am using excel 2016 64 bitt
I have data in col a:j
My key is a&b&c...&j
But it very slow,is so multi Compleks criteria
My data 80.000 row

Please Login or Register  to view this content.

But if using array is very fast
But my data not similar arrange data
Must to sort but so complek data imposibble to sort

Please Login or Register  to view this content.

**Kyle123** · 10-30-2018, 02:59 AM

Don't use worksheet functions on arrays, you may find removing them resolves your issue

**daboho** · 10-30-2018, 03:01 AM

Originally Posted by Kyle123

Don't use worksheet functions on arrays, you may find removing them resolves your issue

What mean
Worksheetfunction
Your mean don't using transpose

**Kyle123** · 10-30-2018, 03:02 AM

Yes, I mean don't use transpose, it's a worksheet function.

Also, your code won't work, you aren't accessing your dictionary, your with blocks are wrong

**daboho** · 10-30-2018, 04:15 AM

Originally Posted by Kyle123

Yes, I mean don't use transpose, it's a worksheet function.

Also, your code won't work, you aren't accessing your dictionary, your with blocks are wrong

Its only simulation
But ok will be test and feed back again

**daboho** · 10-30-2018, 03:06 PM

still very long time to run

Please Login or Register  to view this content.

**shg** · 10-30-2018, 03:09 PM

What is the code supposed to do?

**Arkadi** · 10-30-2018, 03:38 PM

Is "txt" supposed to start blank after each row? Because if it is, then txt = "" is in the wrong place.... by the end of your loop, txt would contain all columns and rows?

Please Login or Register  to view this content.

Not sure how much that would affect the speed, but it just stood out to me

@SHG I gather he is in early stages of a macro, filling in a dictionary with concatenated values for all columns in A:AC?

**daboho** · 10-30-2018, 03:57 PM

Originally Posted by shg

What is the code supposed to do?

Only this code i only see in lokal window but so long to run

**daboho** · 10-30-2018, 03:57 PM

Originally Posted by Arkadi

Is "txt" supposed to start blank after each row? Because if it is, then txt = "" is in the wrong place.... by the end of your loop, txt would contain all columns and rows?

Please Login or Register  to view this content.

Not sure how much that would affect the speed, but it just stood out to me

@SHG I gather he is in early stages of a macro, filling in a dictionary with concatenated values for all columns in A:AC?

Arkadi i am has input to after for i, is same as so very long to run

Why dictionary very slow ,is dictionary have maksimum data

LinkBack

Thread Tools

Rate This Thread

Display

Why dictionary very slow ,is dictionary have maksimum data

Re: Why dictionary very slow ,is dictionary have maksimum data

Re: Why dictionary very slow ,is dictionary have maksimum data

Re: Why dictionary very slow ,is dictionary have maksimum data

Re: Why dictionary very slow ,is dictionary have maksimum data

Re: Why dictionary very slow ,is dictionary have maksimum data

Thread Information

Users Browsing this Thread

Similar Threads

Adding dictionary into dictionary and retrieving data

[SOLVED] Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Function

[SOLVED] How to compare keys in one dictionary to keys in another dictionary

Storing a Dictionary into a Dictionary Object

Dictionary - Using a dictionary of dictionaries to hold individual orders

[SOLVED] Code using dictionary class is too slow- need it work faster if possible.

[SOLVED] Linking MS dictionary as data into Excel

Bookmarks

Bookmarks

Posting Permissions