Cells.Select ' Selects all the cells in the Worksheet (like an EditSelectAll)
Application.Union(Cells(i, 1), Cells(i, 10), Cells(i, 4)).Select ' To select non-adjacent cells
With Selection.Font' Once a range is selected -- you can use this to set the format
    .Name = "Times New Roman"
    .Size = 10
End With
Range("A1").Select' will jump to that particular cell
Cells(ActiveCell.Row + 1, 1).Select' Moving down one cell
Cells(1, ActiveCell.Column + 1).Select' Moving to the right one cell
Range("A1:C1")' another example of range -- used for lowercase "range" BELOW!
ActiveCell.Value' allows you to change the text within the particular selected sell
Cells(1,1).Select' Will select the cell at A1
Cells(RowIndex, ColumnIndex).Select
Cells(ActiveCell.Row + 1, ActiveCell.Column + 2).Select' Moving to a different location - from current location!
Selection.Formula = "=A1*B2"' Sets the formula for the active cell
Selection.Font.Bold = True' Sets the font for the selection to Bold
range.Cells' enumeration object of all cells
range.Cells(n)' nth cell in the range
range.Cells(r, c)' cell at the address given by r row and c column
range.Areas' enumeration object of all rectangular ranges
range.Areas(n)' the nth rectangular range
range.EntireColumn' rows in which the range is located
range.EntireRow' columns in which the range is located
range.Rows(n)' access to individual rows
range.SpecialCells(type)' access to empty, visible, subordinate, etc. type of cells
range.End(xlXxx)' access to last cell in a direction
range.[Direct]Precedents' access to preceding cells (raw data)
range.[Direct]Dependents' access to following cells (formulas)
range.ListHeaderRows' returns the number of header rows