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
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