hide multiple rows

[Guest]

I would like to unhide a few rows based on some condition. Out of these rows,
two rows are hidden using some other condition.

I tried the following:
Worksheets(1).Rows("41:44", "47:51").Hidden = False
(Rows 45 & 46 are to remain hidden)

But this is not working. Please help.

 

[Guest]

Try this:
Worksheets(1).Range("41:44, 47:51").EntireRow.Hidden = False

 

[Guest]

Amit,

try it this way:

With Worksheets(1)
Union(.Range("41:44"), .Range("47:51")).Rows.Hidden = False
End With

 

[Guest]

Dear Cory & Vergel

Thanks to both of you. It worked both ways.