Combination Vba

Reply #5

lottoarchitect — Sun, 18 Apr 2004 22:43:38 GMT

Hi VBA-kid, I've posted a long time ago a very good code to dynamically convert lotteries. Here is the link Lottery SPAN style=COLOR: #000000; BACKGROUND-COLOR: #ffff66>combo/SPAN Question . It is much simpler than the above code you post but it is not in VBA. Hope you find it useful.

Reply #4

Colin F — Sun, 18 Apr 2004 03:13:29 GMT

Vba-KidI like your alias (Aussies are masters of the understatement.).Your problem is a bit hard to fathom out as I think we are losing something in the translation. Having read quite a few times what you are asking the best I can come up with is for a given Combination (what you refer to as an Index) and the position of that Combination in the order of how the combinations were enumerated you want to know which numbers have to that point been included.If my interpretation is correct then I make... [ More ]

Reply #3

Vba-Kid — Sat, 17 Apr 2004 07:14:03 GMT

Hi !Ok , it s not bad you macro, but i need dynamically funktion. So i want exampl. to calculate the lotto numbers ( 6 from 45 ) of the 1.245.082 , i must to run the completely mackro from 1.....to...1.245.082 , and the last line its the result. This take memory and porcessor speed. Only the funktion it s okay, but i want to build into my spreadset and this is a big 9Mb excel database with filter and, other functions to search the top random numbers. Sorry, it is too slow for me, i need a dynami... [ More ]

Reply #2

hypersoniq — Sat, 17 Apr 2004 00:58:43 GMT

the value for N is the max value of rows for excel, without that, you get assorted range errors...

Reply #1

hypersoniq — Sat, 17 Apr 2004 00:57:03 GMT

I adapted this from another forum as originally presented by Gilles D.This is a vba program that will list all combos, provided it doesn't run out of mempry or cell address spaces...Instructions per Gilles D...1 - Open a worksheet and then a module in VBA (Alt-F11)2 - Cut and paste the program I posted into that module3 - Go back to the worksheet and start the program List_Comb4 - Wait a few minutes (less than 2 on mine) and you will get all 165,772 combinations in columns A, B and C. <<< here i... [ More ]

Combination Vba

Vba-Kid — Fri, 16 Apr 2004 21:45:50 GMT

Hello Lotto Masters !Please sorry for my bad english ... i am from Europe , Hungary , Szombathely. I speek only Hungarian and German acceptable. Also i have a problem, i want calculate the lotto numbers from a combination number . Exampl. 1 = 1,2,3,4,5,6 and the 8.145.060 = 40,41,42,43,44,45 , also the last possible combination. I have MS Excel, and want write a VBA - Macro for calculating the real lotto numbers from the Combination number. PLEASE HELP ME ! You are Masters of Lotto , and VB... [ More ]