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

Re: $$Excel-Macros$$ run time error 9 subscript out of range

2014-06-09 Thread Will Sob
Dear Expert, Please look at this code what is wrong with it I'm not an expert in VBA but would need some of your knowledge in this matter I want to put together a formula that takes say a 6/49 lotto and point out say I want to find the most occurring triples, it finds them and show how many times

Re: $$Excel-Macros$$ run time error 9 subscript out of range

2014-06-09 Thread Vaibhav Joshi
Hi change line to LastRow = Workbooks("Quantum R-Creator.xlsm").Worksheets("Dump").Range("E1048576").End(xlUp).Row + 1 If you include workbook name then you need to also add file extension too. Cheers!! On Mon, Jun 9, 2014 at 11:07 PM, Secret Shot wrote: > Dear Expert, > > I am working on a