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
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
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
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
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
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 wrote:
> Dear Expert,
>
> Please look at this code what is wrong wi
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
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
Dear All
I am having vba code not written by me but one of my friend.Now I am facing a
problem while running the same.
This I am using to make a monthly report ,this programe open a indivisual file
from the given folsder and copy paste required data in given excel sheet.
Now when I am try
