RUNTIME 13: TYPE MISMATCH ERROR

[DeanP]

When my workbook opens, I want it to open on a specific worksheet, and hide a few of the rows in that worksheet.

My code is:

Private Sub Workbook_Open()

ThisWorkbook.Sheets("Guide").Activate


ThisWorkbook.Sheets("Guide").Rows("9-60").EntireRow.Hidden = True
 
End Sub

I get mismatch error in the hide rows line of this macro and cannot work out why? Any ideas?

[Fluff]

Replace the - with :

[Artik]

Me.Sheets("Guide").Rows("9:60").Hidden = True

Artik