try it this way:

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

Selection.EntireRow.Hidden = True



"bg18461" wrote:


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:5 3").Select).EntireRow.Hidden
= True

or

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


Any ideas?


--
bg18461
------------------------------------------------------------------------
bg18461's Profile: http://www.excelforum.com/member.php...fo&userid=8877
View this thread: http://www.excelforum.com/showthread...hreadid=315130