I have a situation where i have hide few rows of some other worksheet
based on few conditions in Worksheet change event of the current sheet.

i feel Loop is taking very long time to do tht.
Is thr any way so tht i can select all the rows which r to be hidden
at once and thn make Hidden property as True?