Range("A3:B5")' a range of cells
Range(Cells(3,1), Cells(5,2)).Select' a more useful alternative when selecting multiple cells
Rows("1:4").Select' to select particular rows
Columns("A:D").Select' To select particular columns
Range("A3:B5, C7")' disconnected ranges
Range("name")' access to a named range