C47

HUDDLER
  • Content count

    12,792
  • Joined

  • Last visited


Community Reputation

1192 Awesome

5 Followers



About C47

Profile Information

  • Gender Male
  • Interests sports
    family
    twitter
    gaming
    sports
    travel
    diving
    family
    sports

C47's Activity

  1. C47 added a post in a topic UEFA Champions League Draw   

    Rafa could be fired by Christmas is he doesn't get the attack rolling. Shakhtar will still be tough even with the players they've sent out. Especially heading to Ukraine.
    • 0
  2. C47 added a post in a topic 2015 Summer Transfer Thread   

    Heard it was because Arsenal wouldn't pay the entire fee up front myself. Either way, he's staying. 
    • 0
  3. C47 added a post in a topic 2015 Summer Transfer Thread   

    Right, but coming from someone who watches every RM game I can say that Benz defers a ton to Ronaldo and others. That's one of the reasons that RM who want him out do. They feel he's not ruthless enough in front of goal and he's willing to pass up a good chance to pander to his teammates. What they do with his passes is a whole other story. 
    • 0
  4. C47 added a post in a topic 2015 Summer Transfer Thread   

    How many would he score if he didn't defer to Ronaldo though?
    • 0
  5. C47 added a post in a topic Forwardslash Soccer....   

     
    When are we getting our forum since we beat your stupid little challenge over a year ago?
    • 1
  6. C47 added a post in a topic 2015 Summer Transfer Thread   

    In fairness, Benz isn't really just an "above average" striker. 
    • 0
  7. C47 added a post in a topic 2015 Summer Transfer Thread   

    So like I said...I'll believe Karim is going to Arsenal when he's presented with an Arsenal shirt. 
     
    • 0
  8. C47 added a post in a topic Hey Panther fans   

    We'll give you Cotchery for Cobb straight up. If Aaron Rodgers is as good as they say he is he'll turn Cotchery into Dez Bryant 

    • 1
  9. C47 added a post in a topic In case there are any other Kerrick protesters in or around the stadium tomorrow...   

    Hopefully you took a walk and cleared your head after this post....
    • 0
  10. C47 added a post in a topic TWC Rolling Out Faster Internet Speeds   

    In Concord/Kannapolis area here. Have to wait till 11.04 to get the speed upgrade. Bleh.
    • 0
  11. C47 added a post in a topic 2015 Summer Transfer Thread   

    Man....I hope so, but I just don't believe it. 
    • 1
  12. C47 added a topic in The Lounge   

    Any Excel gurus here? Need help with a work problem and VBA.
     I work with a lot of alphanumeric and numeric characters that look something like this...00D184500002A0880000209100002092000B365130007127400071310000AF823010008310400083105000H831060008701300087414000T874160008741800 Up until now, they've only had leading zeros I need to remove, but now we're getting some with both leading and trailing zeros. What I need is a formula (preferably a VBA macro I can easily just shortcut to) to remove both the leading and trailing zeros from strings of data like this. These values would be formatted as text in the data sheets I'm working with. I was able to modify a formula I found online (see below) to remove leading zeros, so I really only need the trailing ones. Would it be possible to edit this into my working macro, or do I need to create a new macro for trailing? Here's the macro I'm using to remove the leading zeros and it's working flawlessly... Option ExplicitSub removezeros() Dim myCell As RangeDim myRng As RangeDim iCtr As Long With Worksheets("Sheet1")Set myRng = .Range("a1", .Cells(.Rows.Count, "A").End(xlUp))For Each myCell In myRng.CellsFor iCtr = 1 To Len(myCell.Value)If Mid(myCell.Value, iCtr, 1) <> "0" ThenExit ForEnd IfNext iCtrmyCell.Value = Mid(myCell.Value, iCtr)Next myCellEnd With End Sub Anybody have any experience with VBA and can help me out here?
    • 0 replies
    • 89 views
  13. C47 added a post in a topic Convince Me Madden 16 is Worth Buying   

    Cool....so you're the reason it continues to suck? 
    • 0
  14. C47 added a post in a topic 2015 Summer Transfer Thread   

    Strong evidence that RM have signed Mateo Kovacic from Inter.
    • 0
  15. C47 added a post in a topic 2015 Summer Transfer Thread   

    Ronaldo loves Benz because he's willing to defer to him on many occasions. If Benz didn't do that he would have been gone a LONG time ago. I still won't believe this till it actually happens. This transfer has been "close to done" about 6 times in three years. 
    • 1