Archive for July, 2008
Friday, July 25th, 2008 140 views
If you are working on code for any Office application, you might need to reference an object library for another Office application. I've been working on code for a new add-in for Excel, and needed to write code that would reference the appropriate object library, depending on the version of ...
Posted in AddIns, Excel, VBA, automation | 6 Comments »
Tuesday, July 15th, 2008 33 views
If you have been using the code I wrote that duplicates the "Resend This Message" functionality, you may have run into a small problem when executing the code repeatedly on subsequent messages.
Resend This Message
For example, you might execute the code on Message #1 in order to resend it to the ...
Posted in Outlook, VBA | No Comments »
Monday, July 14th, 2008 162 views
Sometimes I have a list of values and want to average them, while excluding zeros or negative numbers, so I use the following popular array formula. "MyRange" is a named range of cells on a worksheet. I discourage the use of magic numbers, but they are included below for visual ...
Posted in Excel, Formulas | No Comments »
Friday, July 11th, 2008 126 views
So I was getting tired of constantly formatting the header row on whatever spreadsheet I am working on, hence this short sub was born. It pretties up the header row and adds autofilter arrows. Most importantly it autosizes the columns so all the information is visible. I chose Teal (ColorIndex ...
Posted in Excel, VBA | No Comments »
