This guide to unleashing the power of Microsoft Excel by using Excel's VBA programming language shows nonprogrammers how to solve real-life problems with Excel VBA. Thousands of concise code samples are accompanied by sample workbooks in a question-and-answer format that describes each specific task.
Hans Herber has a great resource here with 2500 bits of VBA code to do many tasks in Excel. Search the index, find the code, copy and paste into your project.