Try the following:
Worksheets("JAN").Range("7:7,29:29,53:53").EntireR ow.Hidden= True
--
John Green
Sydney
Australia
"bg18461" wrote in message
...
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.Hidd
en
= 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