100th Post and a Code Contest

    In honor of my 100th blog post (which you are reading right now), I'd like to take a moment to recognize a few of my online friends and fellow bloggers who've made my experience more enjoyable, as well as provided valuable support and content for this blog's continued existence. I never thought I'd get this far and had no idea how big this would get when I started. This is not an exhaustive list; it would be far too long otherwise.

• Jon Peltier
• Chandoo
• Debra Dalgleish
• Ross from Methods In Excel
• Mary

    Enjoy the link love!

    So far this year (Jan.1 to today), this site (including blog, but not counting feed) has received the following traffic:

• 49,400 visitors
• 60,300 visits
• 122k pageviews (average 2 pages per visit)
• 167 countries!
• 82% of visitors are first-timers

    We're flirting with 500 feed subscribers, with the feed itself receiving several hundred hits per day. Traffic and readership has increased dramatically since the end of September, with the average number of visitors around 350 per day.

    And of course the readers, commenters and visitors to this site deserve a HUGE thank you for your continued support!

Code Contest

    To that end, I'm announcing a contest to highlight useful Excel and Outlook VBA code. Send me your favorite Excel or Outlook VBA code and explain what it does, how to use it, and why it's so useful to you. I'll post all of the entries here, and provide an email address for site visitors to vote on their favorite. The person who receives the most votes will receive my personal copy of "Accessing and Analyzing Data with Microsoft® Excel" by Paul Cornell, Microsoft Press.

    The runner-up will receive my copy of "On Time! On Track! On Target!" by Bonnie Biafore, Microsoft Press.

Contest Rules

    Email your entries to contest@codeforexcelandoutlook.com. Entries must be received by 12:00 AM EST on December 23rd, 2008. Entries remain the property of their respective owners. Limit two entries per person. Include your contact information (email & mailing address, and a link to your website or blog if available) when submitting your code. The code must be compiled and actually work. Entries will be tested for usability; I need to be able to drop the code into a module with Option Explicit and have it work properly the first time. Only submit code that you've written or adapted yourself, and are willing to share with others; your code will be checked for originality. If the code doesn't work or is clearly copied, or has proprietary information in it, I will send it back. Also, make sure you indicate version compatibility and international issues (if any) when submitting your code.

    Please submit only one subroutine, unless your code requires multiple subs to work. For example, a main sub which does most of the work, with one or two "black box" functions that perform single-purpose calculations passed back to the main sub. Please do not submit entire workbooks, applications or add-ins, just subroutines or functions in txt format or pasted into the body of the email. Your contact info is only used to communicate with you about the contest, and mail you the prize (if applicable). All contact info is destroyed at the conclusion of the contest.

    I will post all the entries after December 23rd and provide an email address for site visitors to vote. Voting will close approxmately one week after that post.

– end –

    In other news, I've added some new feeds to each post. You can subscribe to the comments feed for a particular post by following the link "Subscribe to Comments" at the bottom of the post. So now there are three types of feeds you can subscribe to:

• The posts feed (all blog posts)
• The comments feed (all comments regardless of post)
• The comments feed for a particular post

    You can also follow post comments by filling out the "Subscribe without commenting" textbox at the bottom of the comment box for a particular post. You'll receive an email whenever someone comments on that post.

    I'd also like to mention there's an Excel user conference going on in London next year. There's an informative post about the EUC on Nick Hodge's blog.

↑ Scroll to top
Previous Post: My guitar rig drawn in Excel
Next Post: SearchBox Week, Day 1