hiding rows on worksheets

[bg18461]

I have a macro that will hide/unhide certain rows on sheets in my
workbook, however i get ' Object doesn't support this property or
method' error when i use the code below:

Worksheets(Worksheets("JAN").Range("7:7,29:29,53:53").Select).EntireRow.Hidden
= True

or

Sheets("JAN").Range("7:7,29:29,53:53").Select
Worksheets("JAN").Selection.EntireRow.Hidden = True


Any ideas?

 

[John Green]

Try the following:

Worksheets("JAN").Range("7:7,29:29,53:53").EntireRow.Hidden= True

 

[Guest]

try it this way:

Sheets("JAN").Range("7:7,29:29,53:53").Select

Selection.EntireRow.Hidden = True