My best advice for you is to simply turn on Excels macro recorder, record some actions, and then look at the Visual Basic Editor to see what was recorded. From there you can edit the code and copy/paste modifications of specific lines in the "immediate" window, which is there for you to test code.
The macro recorder records a lot of crap and surprisingly does not record macros efficiently. You can cut out a lot of the crap lines to speed up the code. There are othe tricks to speeding up your macros, such as turning off screen updating and writing code that performs actions on cells or ranges without actually "selecting" the cells.
I've found some really simple but useful macro codes on the net. One of them emails my spreadsheet to a predetermined email list without me even clicking on Outlook and automatically updates the subject of the message based on whatever today's date is. I'm about halfway through the John Walkenbach "power programming excel vba" book. It has some cool examples but in my opinion doesn't do enough to explain all of the basics.