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

listi.net

.Select Method

The Select method applies to many objects. Some VBA examples are:

Cells.Select ' selects all cells

Cells(1,3).select 'selects cell C1

Range("A2").Select ' Selects cell A2

Range("A1:D4").Select ' selects from cells A1 to D4

Sheets("Test").Select ' Selects the sheet named test. If test doesn't exist you get an error

Sheets(sh).Select ' Selects the sheet named in variable sh

Rows("2:3").Select ' Selects rows 2 and 3

Columns("A:C").Select 'Selects Columsn A through C