Freelancer: rnogales
Tee ilmoitus työstä

Code optimization macro-vba Excel

The speed for compute de process finish in 45 seconds, I have optimized the excel code to allow faster computing. I've seen others proposals here, but there are errors: 1.- People show in cells the same data, same numbers, not different. 2.- Don't catch 22 digits 3.- Check the code of these proposals because I think that they are not choosing the previous two columns with numbers randomly to take 22 digits like you can see in their pictures. That's why they show only 2-4 seconds

                                                                                                            Kilpailutyö #                                        33
                                     kilpailussa                                         Excel Macro

Julkinen selvennystaulu

  • rnogales
    • 3 kuukautta sitten

    Sorry, I've have errors, I'll send a picture with updated information about my results.
    I understood bad some requeriments, I've changed the code to obtain the exercise and the button to start the process. I've used for loops and other tricks to improve the computation

    • 3 kuukautta sitten
  • iworship2006
    Kilpailun järjestäjä
    • 3 kuukautta sitten

    Thanks. I will be checking to insure they generate the data properly. I will be doing various tests.

    • 3 kuukautta sitten