Excel Formulas for Consecutive Numbers

[gsobier]

...we already broken enough rules like being off topic already...

Oh, I know about the e-mails ...we don't wanna make LT mad ...

 

[tomtom]

...we already broken enough rules like being off topic already...

Well, I think PAB got what he was looking for in the meantime..therefore, it shouldn't be a big deal.......however, gotta check the last PAB's post...

 

[tomtom]

Re: Hi GillesD,

Sorry for being a bit out of topic PAB. So,

Thanks for the Reply,

I have Tried Several Ways to get it to Start the Output in Cell "A1" But to NO Avail.
How would I get it to Also Print the Totals for the Number of Combinations Please.

Thanks in Advance.
All the Best
PAB

 

[tomtom]

..if you know my e-Mail, send away.. ...we are not allowed to exchange e-Maill addresses here...

Well, it was one at your web site before...it seems it doesn't work any more...so, maybe some other time..However, good luck with that 50 cents/ticket one...

Sorry again PAB.

Thanks for the Reply,

I have Tried Several Ways to get it to Start the Output in Cell "A1" But to NO Avail.
How would I get it to Also Print the Totals for the Number of Combinations Please.

Thanks in Advance.
All the Best
PAB

 

[PAB]

No Worries tomtom,

Not Quite there yet, But Really Close .
If GillesD is Able to get the Output to Start in Cell "A1", and Manage to get it to Print the Grand Total for the Number of Combinations, it will be Complete.

All the Best
PAB

 

[tomtom]

If GillesD is Able to get the Output to Start in Cell "A1", and Manage to get it to Print the Grand Total for the Number of Combinations, it will be Complete.

All the Best
PAB

Well, hope you will get the thing soon. BTW, already knowing the final results why a lottery player would need such a macro ? Just for learning some VBA?

 

[PAB]

Hi GillesD,

I Managed to get it to Print the Total Combinations Directly After the Totals for EACH Distribution, there is Probably a Far Simpler and Elegant Way to do this, But at Least it Works.
Unfortunately I Still Can't get it to Start Printing in Cell "A1", have you got Any Ideas Please.

Next F
Next E
Next D
Next C
Next B
Next A
Range("A1").Select
For I = 1 To 11
ActiveCell.Offset(I, 0).Value = nType(I)

********* This Totals the Combinations *********

ActiveCell.Offset(12, 0).Value = nType(1) + nType(2) + nType(3) _
+ nType(4) + nType(5) + nType(6) + nType(7) + nType(8) _
+ nType(9) + nType(10) + nType(11)

******************************************

Next I
End Sub

Thanks in Advance.
All the Best
PAB

 

[bloubul]

GillesD

I can't get it to work? Will you please send me a copy of your spreadsheet please.

BlouBul

 

[tomtom]

Re: Hi GillesD,

I Managed to get it to Print the Total Combinations Directly After the Totals for EACH Distribution, there is Probably a Far Simpler and Elegant Way to do this, But at Least it Works.
Unfortunately I Still Can't get it to Start Printing in Cell "A1", have you got Any Ideas Please.

Next F
Next E
Next D
Next C
Next B
Next A
Range("A1").Select
For I = 1 To 11
ActiveCell.Offset(I, 0).Value = nType(I)

********* This Totals the Combinations *********

ActiveCell.Offset(12, 0).Value = nType(1) + nType(2) + nType(3) _
+ nType(4) + nType(5) + nType(6) + nType(7) + nType(8) _
+ nType(9) + nType(10) + nType(11)

******************************************

Next I
End Sub

Thanks in Advance.
All the Best
PAB

Hey PAB
It seems GillesD is bussy or something, so even I did't try this thingy nor I'm interested in, here is just a small advice for you - try

ActiveCell.Offset(I-1, 0).Value = nType(I)

Good luck

 

[tomtom]

Re: Re: Hi GillesD,

Hey PAB
It seems GillesD is bussy or something, so even I did't try this thingy nor I'm interested in, here is just a small advice for you - try

ActiveCell.Offset(I-1, 0).Value = nType(I)

Good luck

Well , the way I posted this seems a bit rude and since I'm a quite polite guy just to explain- I'm neither interested for what do you need this little thingy, nor I'm interested to use it at all, therefore just pointing to a very obvious solution in case I understood your question good .

 

[PAB]

Hi tomtom,

I have Managed to Work it Out , But Thanks Anyway.

Have a Good Weekend.
All the Best
PAB