Code Question

[Winalot2007]

I found VBA code for generating Pairs.

I copied the Texas 12/24 game history and ran the macro.

For some reason the Pair 19/21 is not calculating. Every Pair is correct except 19/21.

Here is the download link to the Excel file:
https://app.box.com/s/969vrsr3f7l62ofbirohk06zy20wv43a

The original file was posted here:
http://www.techonthenet.com/excel/macros/pairs.php

Hopefully someone can explain why just the 19/21 pair is the only pair not being calculated.

Thanks

 

[Winalot2007]

I think I figured out the problem. I added an additional line (row) to he history. For example, if the history is range D20:O2822 I changed the code to D20:O2823.

 

[larbec]

Hi winalot, I don't visit the board enough. Did you solve your issue? If not, I'll be glad to take a look at it

 

[larbec]

Just thinking, is this for the AON game? I'm from East Texas. If so, I may have something that might interest you. I too search for pairs on other games but when I wrote the Macro I made it capable to search for multiple pairs I.e. 2-4-6-8-10 or all 12 numbers I play the Lotto Texas, Two Step and PB mostly

 

[blitzed]

hiya larbec, cool I have some friends in TX.

yeah Lotto Texas looks like a good game...a shame most states only offer the super longshot type monster lottery games.

I would be more than happy to play a game which offers wins around $2million or more, I'm not greedy

I am in CA, SuperLotto Plus resets to $7million, but odds suck at 41,416,353
http://www.calottery.com/play/draw-games/superlotto-plus/how-to-play

I almost nailed it once, 2 numbers were offset by "1"

later,
blitzed

Just thinking, is this for the AON game? I'm from East Texas. If so, I may have something that might interest you. I too search for pairs on other games but when I wrote the Macro I made it capable to search for multiple pairs I.e. 2-4-6-8-10 or all 12 numbers I play the Lotto Texas, Two Step and PB mostly