Find lotteries Repetitions patterns on past results

Reply #6

timmsy — Tue, 05 Dec 2017 08:09:38 GMT

Anyone picked winning numbers using this Excel macro yet

Reply #5

TooTallLuke — Fri, 24 Nov 2017 02:00:57 GMT

Works really well, thanks

Reply #4

pavizlo$ — Wed, 22 Nov 2017 16:17:47 GMT

Thank you Timmsy, good stuff. Would explain again how to use this program? I am still getting a run time error. Please explain briefly on Numbers range.

Thank you,

Reply #3

timmsy — Tue, 21 Nov 2017 10:37:41 GMT

hi TooTallLuke you have to Create a named range called Numbers , i have uploaded an example for you

https://1drv.ms/u/s!Ag3gOZ6aEeT_gQ91q0Lc71qIs3Qt

Reply #2

TooTallLuke — Mon, 20 Nov 2017 12:56:47 GMT

I tried to run it and got error Run time error '424' Object required?

Debug error points to = For Each Rw1 In [Numbers].Rows

Reply #1

timmsy — Mon, 20 Nov 2017 07:39:41 GMT

ok here is the vba code so far :::

Public Sub Highlight_Repetitions()

REPEATS = Application.InputBox( How many numbers would you like to find Repetitions: , Type:=1)

Dim Rw1 As Range, Rw2 As Range

Dim check_array As Variant, match_array As Variant

Sheets( sheet1 ).Select

Application.Calculation = xlCalculationManual

Range( a1:t1 ).Select ' first draw (first 5 balls)

Do While ActiveCell.Value 0

Selection.Offset(1, 0).Select

Selection.Sort Key1:=Ac... [ More ]

Find lotteries Repetitions patterns on past results

timmsy — Wed, 15 Nov 2017 09:46:48 GMT

Almost completed a excel macro that Finds lotteries Repetitions patterns on past results. the output looks like this

the look for 5 numbers patterns out of 37 numbers output looks like this after the macro runs :

(((note ::: this is only part of the output looks like )))

Rows 2 and 20 have repetitions 6 11 13 26 28

Rows 2 and 70 have repetitions 6 16 26 28 29 31 34

Rows 2 and 118 have repetitions 11 13 26 29 31

Rows 2 and 176 have repetitions 10 11 26 28 31

Rows 2