Vb6 turn off screenupdating
I do not know how to use code or highlight tags to post codes. In answer to your question, the code takes just about 3 to 4 minutes to run – quite fast. On the issue of whether the term Milk used in the last code he posted should be permutation or combination, I am very certain that, given what you desired to achieve in your original thread, it is combination and not permutation.If I know, I would ensure that the code is posted exactly the way it came to me, so that you’d see it in the proper code format. The information below may be useful: Combination is just a selection of certain objects, the order does not matter because we are just creating a group of objects.If you will like to see the code for the combination, let me know, and as soon as I receive it tomorrow, I will copy it and paste for your information. Kenny i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next Thanks Pete for pointing me to your thread. I prefer your idea of generating 6 number combinations, each with a sum within a certain range (in this case 160 – 175).Could you kindly suggest and insert into the code any line or lines that could be added to it the achieve that, please. Kenny as far as i can remember this project was shelved, without any particular resolution (pressure of work at the time), i have no idea if i still have any of the code from then how long does that code take to run?
Status Bar = False End Sub (Please note that because I cut and pasted here, all the lines that were indented showed up on a straight left indent.I would like to use the code that worked for you, please.This will help me cut down on the number of combinations that I eventually get from my 6/30 combinations.I would rather have them in separate worksheets so as not to create problems for myself.If you can please help with this matching part (see my post #1 paragraph 3), I will be very happy.