When I use:
Worksheets("JAN").Range("7:7,29:29,53:53").EntireR ow.Hidden= True

or

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

I now get the error:
'Select method of Range class failed'

Any other suggestions

--
bg1846
-----------------------------------------------------------------------
bg18461's Profile: http://www.excelforum.com/member.php...nfo&userid=887
View this thread: http://www.excelforum.com/showthread.php?threadid=31513