Community Code Challenge
Hi all, being a member of Excel Forum means you are a member of the greatest Excel community on the web, big claim?, maybe!, true?, definitely!, take a look at all the other forums available, we are one of the largest, one of the friendliest and definitely one of the most organised!
I’d like to prove the organised theory with a small challenge, below you will see the beginnings of a sub, I would ask anyone who reads this to post comment by means of adding no more than 6 lines of code to the sub and tag your insertions with a ‘ and then your initials, the code must be valid and workable and you may not change anyone else’s additions but may work them in to your code.
The idea is after the expiry date at the end of this blog we will be able to run the code on a worksheet and have something fun and tangible, each of you will get the completed worksheet mailed to you where you can further adapt or experiment and you will all get your name in a hall of fame here, you can contribute to the code 3 times but not consecutively & you may only use the variables given.
Good luck to us all!
Public Sub CCC()
Dim Rng As Range, MyCell As Range
Dim I As Long, c As Integer
Dim S As String, T As String
Dim r As Variant, m As Variant
Expiry date 20th December 2008
- Thursday, November 13th, 2008
- Comments (10)
Leave a Reply