The three words in VBA Excel that you will use the most to move around the worksheet are: Range, Offset and Select. Always use Range rather than Cells.
www.excel-vba.com