The site formerly known as Code For Excel and Outlook
June 6, 2011 by · 
In Which macro shortcut keys do you use I posted the code I use to clean up my worksheets. Since then I've revised the code somewhat. The fact that my computer crashed and I lost my personal.xls workbook had absolutely nothing to do with this decision.
Continue Reading: Clean up your Worksheet »
July 13, 2010 by · 
Ever set up a monster spreadsheet with dozens of columns, then autofilter it, then forget which columns are autofiltered?
The little autofilter arrows turn blue when a filter is applied, but who wants to lose their eyesight scrolling across a worksheet looking for which ones are in effect?
Continue Reading: What columns are filtered? »
July 11, 2008 by · 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 14) but if you want to change that, check out Dave McRitchie's excellent color palette page for a list of the colors you can use.
Continue Reading: Format header row »
March 29, 2008 by · Good morning,
I am pleased to announce that the Data Filter Tool add-in has been completed. I will be posting a fuller announcement on The Coding Pad, but for now I would like to make this add-in available for anyone who wants to try it.
Continue Reading: Data Filter Tool and dmoz.org announcement »
Site last updated: February 9, 2012
Follow Me