The site formerly known as Code For Excel and Outlook
November 12, 2009 by · 
In Going Back to the Topic of Functions For a Moment…, Excel Program Manager Joseph Chirilov posted a PDF containing information about improved functions in Excel 2010. These changes were introduced in a previous post on the same blog. Some functions have new names to make the interface more consistent, while others are becoming more accurate.
Continue Reading: Excel 2010 Function Improvements »
May 7, 2009 by · If you wanted to specify default parameters for a function, here's how to do it in VBA.
Use the Optional keyword when specifying your function's parameters, and enter a default value if no parameter is passed to your function.
Continue Reading: Setting default function parameters »
January 7, 2009 by · If you have multiple mail profiles set up in Outlook, you might need VBA code that acts on items in several different inboxes (instead of just your own). Typically you'll see this in an environment where Exchange Server is running. Hold on, there's a lot of VBA code in this post!
Continue Reading: Handling Multiple Inboxes »
Site last updated: February 9, 2012
Follow Me