.Activate è lo stesso. Anzi .Select è utilizzato per selezionare un range ed ha come effetto
'collaterale' in mancanza di un range, quello di attivarti, comunquel lo sheet.

1: How to Select a Cell on the Active Worksheet
To select cell D5 on the active worksheet, you can use either of the following examples:


ActiveSheet.Cells(5, 4).Select

-or-

ActiveSheet.Range("D5").Select


2: How to Select a Cell on Another Worksheet in the Same Workbook
To select cell E6 on another worksheet in the same workbook, you can use either of the following examples:


Application.Goto (ActiveWorkbook.Sheets("Sheet2").Cells(6, 5))

-or-

Application.Goto (ActiveWorkbook.Sheets("Sheet2").Range("E6"))


Or, you can activate the worksheet, and then use method 1 above to select the cell:

Sheets("Sheet2").Activate
ActiveSheet.Cells(6, 5).Select

Leggi su MSDN l'articolo : Q120198.