Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Ok. I solved part of the question I presented above: I now use a scripting dictionary to store the calculation in memory. At the end of the sub-routine, the calculations (in this case all relative primes to a given modulus) are displayed in Column B. Much Faster! This code is good. Four-digit mods take a few seconds, six-digit mods take a long time....my next goal is to make a VBA version of the extended euclidian algorithm which should be much quicker. I still need help on the second part of my question: Is it possible to sort the calculations from lowest to highest WHILE THEY ARE ITEMS IN THE DICTIONARY? (i.e. while they are in memory) so I can list them in Column B. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding primes | Excel Discussion (Misc queries) | |||
storing data | Excel Worksheet Functions | |||
Storing data | New Users to Excel | |||
Storing various data in .ID property | Excel Programming | |||
Storing data between sessions | Excel Programming |