Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-12 Thread Vaibhav Joshi
I m still not clear, can you explain 1st line of Input and how you derived result. On Thu, Jun 12, 2014 at 1:34 AM, Will Sob wrote: > Hi Joshi, > > this is my data > 7 9 18 24 39 40 4 18 26 32 36 40 45 21 10 31 35 40 41 44 46 2 5 9 28 > 29 48 36 10 19 20 33 45 46 25 15 26 29 35 36 41 19

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-11 Thread Will Sob
Hi Joshi, this is my data 7 9 18 24 39 40 4 18 26 32 36 40 45 21 10 31 35 40 41 44 46 2 5 9 28 29 48 36 10 19 20 33 45 46 25 15 26 29 35 36 41 19 3 5 8 10 16 17 46 16 17 22 38 44 49 14 1 7 9 27 30 48 28 9 25 34 37 44 45 6 17 22 23 33 36 42 12 16 18 29 34 35 39 40 13 20 31 34 36 44 11

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-11 Thread Vaibhav Joshi
hi can you illustrate an example.. we can help you on that.. Cheers!! On Wed, Jun 11, 2014 at 2:17 AM, Will Sob wrote: > thanks it did work but it did not build the triplets i specify > > it just calculated it to 18424 > > > On Tue, Jun 10, 2014 at 6:19 AM, Vaibhav Joshi wrote: > >> Here you

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-10 Thread Will Sob
thanks it did work but it did not build the triplets i specify it just calculated it to 18424 On Tue, Jun 10, 2014 at 6:19 AM, Vaibhav Joshi wrote: > Here you are declaring Dim tbl(1 To ntbl, 1 To 2) As Long > > when vale of m drops belwo 1 you will get error 9 > > change lines to.. > > Dim tb

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-09 Thread Vaibhav Joshi
Here you are declaring Dim tbl(1 To ntbl, 1 To 2) As Long when vale of m drops belwo 1 you will get error 9 change lines to.. Dim tbl(0 To ntbl, 1 To 2) As Long can comment whether this will work without your sample data. Cheers!! On Tue, Jun 10, 2014 at 10:41 AM, Vaibhav Joshi wrote: > He