The site formerly known as Code For Excel and Outlook
January 13, 2010 by · 
I recently had to use the code I posted in Clean and Repair Your Access Database to delete blank records from a database. But it failed because one of the tables has spaces in the name. I didn't create the table, I swear!
Continue Reading: Updated Access VBA code to delete empty records »
August 31, 2009 by · This is a cute trick that can be used to impress your boss or co-workers, if they happen to be walking by. Just place any of these code blocks in the sheet module behind a worksheet, then click around the worksheet. Don't use a worksheet that already has cells with fill color, as these procedures will wipe them out.
Continue Reading: Color your Target »
December 8, 2008 by · I thought I'd share a program I wrote in Java to solve a simple problem. It sums the multiples of three from 1 to 100. In other words, it loops through the numbers 1 to 100, and if it finds a number that is a multiple of three, it adds the number to the total.
Continue Reading: Testing my Java solution with Excel »
Site last updated: February 8, 2012
Follow Me