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.