VBA Training Video from ExcelExperts.com - what does my recorded code mean ?
This video explains how to record a macro, and then how to condense the code into a single line.