Friday, 11 August, 2006

1. By . Comment posted 11-Aug-2006 @02:16pm:

   If Joe Blow wins, I am going to accuse him of cheating.
2. By Jackson. Comment posted 11-Aug-2006 @02:19pm:

   Quick, everybody! Run to your "Prayer Antennas"
3. By TimS. Comment posted 11-Aug-2006 @02:25pm:

   This is so exciting. I wish I'd participated.
   But I just couldn't take a chance on being he winner.
4. By john weeks. Comment posted 11-Aug-2006 @02:41pm:

   When I win, I'll use the prize to convert souls to the truth and rightiousness of our fine lord and holy savior.
   those who reject me and my lordlet will forever be cast into a lake of fire or an excel spreadsheet, not unlike the one mentioned above, whichever is more annoying.
   Those that agree with me and accept the J-man will forever eat bacon at the foot of god.
   amen
5. By . Comment posted 11-Aug-2006 @02:45pm:

   Please let us know how many times Excel 2007 crashes during this exercise. :-)
6. By Mean Jean. Comment posted 11-Aug-2006 @02:47pm:

   Oh, this is waaaaaay to complicated. I'm gonna go drink some nice, chilled rose'. I'll check my email and this site periodically.
   
   This process will give Jim and Esther time to move.
7. By major_danny. Comment posted 11-Aug-2006 @02:49pm:

   Ok. What's the big blue button? Have you given your computer a name?
8. By wally the duck. Comment posted 11-Aug-2006 @02:57pm:

   Is it open mic yet?
9. By . Comment posted 11-Aug-2006 @03:04pm:

   Just to see how good John's processes are, I click the Button at 3:02 and was given the "too late" notice. What a SysAdmin!
10. By . Comment posted 11-Aug-2006 @03:11pm:

    Where are the results? Is the macro still compiling?
11. By . Comment posted 11-Aug-2006 @03:18pm:

    The winners have been selected, and notified.
    
    The first place winner bought 10 chances, and the second place winner bought 2.
    
    Looking at the ranked list, I see that Wendy! would have been a winner if we had 10 prizes.
12. By Mean Jean. Comment posted 11-Aug-2006 @03:19pm:

    How much money did you make?
13. By . Comment posted 11-Aug-2006 @03:22pm:

    180 chances were sold which = $360 for WWR.
14. By Pancho. Comment posted 11-Aug-2006 @03:24pm:

    I WON!! I WON!!!
    
    Yipppeeee!!!
15. By Pancho. Comment posted 11-Aug-2006 @03:25pm:

    I want the Excel book! Sorry for the 2nd place...
16. By . Comment posted 11-Aug-2006 @03:45pm:

    $360... Sounds like the Wheatheads won. Go Wheatheads.
17. By . Comment posted 11-Aug-2006 @03:59pm:

    I WAS SO CLOSE! I CAN TASTE IT!
18. By Mean Jean. Comment posted 11-Aug-2006 @03:59pm:

    Ewwwwwwwwww go rinse your mouth out, quick!
19. By Eenie Meenie. Comment posted 11-Aug-2006 @04:18pm:

    The only thing I've ever won in a raffle was a Shetland pony. A mean, biting Shetland pony, named Woodstock. It was at some tack shop I used to frequent. But, I did win in the end. I sold him for $275.00 and I only paid a buck for the ticket.
20. By Eenie Meenie. Comment posted 11-Aug-2006 @04:28pm:

    But, I didn't win Faith Mountain and now I am crushed.
21. By wally the duck. Comment posted 11-Aug-2006 @04:44pm:

    It started as a gag gift and ended up with a generous donation to WWR. This is truly the work of the Lord. Amen Amen. Halleluja.
    
    Hmmm... is that how you spell that word?
22. By Thrash Cardiom. Comment posted 11-Aug-2006 @05:15pm:

    I'm so disappointed that I didn't win the Faith Mountain. You just can't buy that sort of trash in my country.
23. By biff. Comment posted 11-Aug-2006 @08:39pm:

    I WAS SO CLOSE! I CAN TASTE IT!
    
    Ewwwwwwwwww go rinse your mouth out, quick!
    
    rotflmao!
24. By Jim Kloss. Comment posted 12-Aug-2006 @05:57pm:

    Is there a 12-step program for those of us who were addicted to the Faith Mountain experience?
25. By wally the duck. Comment posted 13-Aug-2006 @08:43am:

    Fear not, Jim, your experience may not yet be over.
26. By Joe Schmidt. Comment posted 24-Aug-2006 @02:08am:

    Any chance I can look at the macro you wrote to to duplicate the rows for anyone who purchased more than one ticket? I going to be doing the same type of auction in the next few weeks (though not for a big faith mountain), and being the excel noob that I am, would find this quite handy.
    
    Thanks.
27. By . Comment posted 24-Aug-2006 @08:08am:

    
    Sub DupeRows()
    Dim cell As Range
    Set cell = Range("A2") ' 1st cell with number of chances
    Do While Not IsEmpty(cell)
    If cell > 1 Then
    Range(cell.Offset(1, 0), cell.Offset(cell.Value - 1, 0)).EntireRow.Insert
    Range(cell, cell.Offset(cell.Value - 1, 1)).EntireRow.FillDown
    End If
    Set cell = cell.Offset(cell.Value, 0)
    Loop
    End Sub
    </pre>

Original content © 2010, John Walkenbach