Search

Macros in excelReply
the problem is it doesn't automatically update when you make changes, you have to re-enter the data... and copy/paste brings up a runtime error.here's a variation that highlights v-trac numbers in the A1:A10 rangePrivate Sub Worksheet_Change(ByVal Target As Range)Dim icolor As Integer If Not Intersect(Target, Range( A1:A10 )) Is Nothing Then Select Case Target Case 0 icolor = 2 Case 1 icolor = 3 Case 2 icol
Dec 17, 2005, 4:25 pm - hypersoniq - Lottery Discussion Forum

Editor data transmission modificationReply
Thanks Todd,Worked very well, however, for very large tables I have a problem.I will get a timeout error when trying to send very large tables.I don't have this problem when I just send plain text in the format I've created on my end.The overall problem is, when I spend alot of my time creating something that will add value to the Lottery Post and see that work get ruined, I get a little disappointed.I hope we can work this problem and find a solution that makes everyone happier.
Dec 17, 2005, 1:45 pm - JADELottery - Suggestions Forum

The combinatorics of a permutationReply
...Now, the tricky math part.Using the values of MIN, MAX, SUM, and PRODUCT we can find the values of X_LOW and X_HIGH.Taking the SUM of W, X, Y, and Z, if we subtract the values of MIN and MAX we are left with the sum of the two middle numbers X_LOW and X_HIGH. Sum of X_LOW and X_HIGH: n = SUM - MIN - MAXTaking the PRODUCT of W, X, Y, and Z, if we divide out the values of MIN and MAX we are left with the product of the two middle numbers X_LOW and X_HIGH. Product of X_LOW and X_HIG
Dec 16, 2005, 6:58 pm - JADELottery - Mathematics Forum

Maybe I am not saying what I meanReply
Sub UniqueList() Dim rListPaste As Range Dim iReply As Integer On Error Resume Next Set rListPaste = Application.InputBox _ (Prompt:= Please select the destination cell , Type:=8) If rListPaste Is Nothing Then iReply = MsgBox( No range nominated, _ terminate , vbYesNo + vbQuestion) If iReply = vbYes Then Exit Sub End If Range( A1 , Range( A65536 ).End(xlUp)).AdvancedFilter _ Action:=xlFilterCopy, CopyToRange:=rListPaste.Cells(1, 1), Unique:=TrueEnd Sub
Dec 16, 2005, 2:06 am - lottaloot - Lottery Discussion Forum

Site Problem 12/5Reply
Nope, I checked the logs for the site, no problems at all. The only issue was a glitch in the login code (which Powerplayer notified me about - thanks), but there was nothing that would cause a 500 error.Sometimes network connections break somewhere between your ISP and a web site's location, making you think the site you're trying to reach is down. That kind of thing doesn't affect huge websites like Google or Yahoo, because they have backup servers all over the world, but it does affect most
Dec 7, 2005, 2:59 pm - Todd - Lottery Discussion Forum

Vtracs 102Reply
MID EVE 710 V321 172 V233 151 V212 002 v113011 V122 271 V332no draw 872 V433305 V411 831 V442 V trac 5 last seen 11/29/05 204 V315 743 V354 I see the last time vtrac 5 fell it was with the 5. So do I make strings and play vtracs 532 or 534? Am I getting there?made an error
Dec 6, 2005, 10:38 am - misssally - Lottery Systems Forum

Ok this doesn't look right.Reply
With this disclaimer below those results:Please note every effort has been made to ensure that the enclosed information is accurate; however, in the event of an error, the winning numbers and prize amounts in the official record of the Florida Lottery shall be controlling.They can't held to that.
Dec 4, 2005, 5:04 am - RJOh - Lottery Discussion Forum

Thanx ToddReply
Yea I have been having major problems with this site again within the last week or so. Very slow load times, 500 error messages thus losing all my posts, etc. Was smooth for awhile, but then back to being slow again.
Dec 1, 2005, 10:07 pm - sirbrad - Lottery Discussion Forum

Vtracs 101Reply
I can easily print out a hard copy of the whole thing or any selected range of it.I am hoping to use some of the more advanced tools like conditional formatting to make different things easier to see, thus making the whole study part more efficient and less prone to personal error or oversight... plus, any errors will be WAY easier to fix in an electronic format (vs. the dreaded eraser).but for now, my knowledge of v-tracs is what you have put forth in this thread, so I am anxiously awaiting vtr
Nov 26, 2005, 12:24 pm - hypersoniq - Lottery Systems Forum

Arlene's Profit/Loss Center, UpdatesReply
opps..I too made a error...cost of play is 30.00 per draw..but I didn't multiply it by the number of states.. cost of play .50 box/.50 straight x 30 sets = 30.00 x 5 states = 150.00 per draw 2 draws per day is 300.004 draws from 11/22 midday thru 11/23 evening x 150.00 = 600.00I didn't figure in the double box...so 75.00 to payoutsso cost of play is 600.00total payouts is now at 825.00profit/loss is + 225.00
Nov 24, 2005, 3:15 pm - dman2005 - Lottery Systems Forum