hide multiple rows
Dear Cory & Vergel
Thanks to both of you. It worked both ways.
"Amit" wrote:
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.
|