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 will00...@gmail.com 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

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 will00...@gmail.com 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

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 v...@vabs.in 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..

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

2014-06-09 Thread Vaibhav Joshi
Hey Will Welcome! You need to start new thread as per forum rule so that you get attention proper resolution of your solution.. Did this code worked proper;y previously ? Cheers!! On Tue, Jun 10, 2014 at 1:24 AM, Will Sob will00...@gmail.com wrote: Dear Expert, Please look at this code

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 v...@vabs.in