Hi all, I'm trying to create a macro that will hide a sheet and unhide a different sheet and select a cell in the unhidden sheet. I keep getting a run-time error of 1004.

Private Sub CommandButton1_Click()

Application.ScreenUpdating = False
Sheets("SMT Selection Process").Visible = False
Sheets("Employee_List").Visible = True
Sheets("Employee_List").Select
Range("A1").Select

End Sub

It doesn't like the "Range("A1").Select, I'm using Excel 2007.

Thanks guys.