hiding rows on worksheets
 

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

hiding rows on worksheets
 

You would get that error with the code that uses Select if the Jan worksheet
were not active and visible at the time of running the code.

On the other hand

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

or

Worksheets("JAN").Range("A7,A29,A53").EntireRow.Hi dden= True

will work as long as the Jan sheet is in the activeworkbook. I don't see how
you could get a "Select method" error when the code does not use the Select
method.

If Jan is not in the active workbook, use something like:

Workbooks("Book1.xls").Worksheets("JAN").Range("A7 ,A29,A53").EntireRow.Hidde
n= True



--
John Green
Sydney
Australia


"bg18461" wrote in message
...

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.


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