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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

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