hiding rows on worksheets

[bg18461]

When I use:
Worksheets("JAN").Range("7:7,29:29,53:53").EntireRow.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

 

[John Green]

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").EntireRow.Hidden= True

or

Worksheets("JAN").Range("A7,A29,A53").EntireRow.Hidden= 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