By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

Range("A1").select (dup)

The Select method acts on a Range object of the cell being selected

This is top statement you'll use.

In the Immediate window try the following

Immediate Window

Range("A2").Select

Range("A1:A10").Select

Range(A1:B20).Select

Range("A1,B2,C3,D4,E5").Select

Once a cell is selected it becomes ActiveCell