Range("A1").Select ' Selects only cell A1 Range("A:A").Select ' Selects the entire A column Range("1:1").Select ' Selects the entire 1 row Range("A1:C5").Select ' Select the box from A1 to C5 Range("A1","C5").Select ' Same thing as above; just a different syntax Worksheets("Sheet2").Range("A1").Select ' Selects A1 on the Worksheet 'Sheet2'