Hi xld

Many Thks for looking in to this.

Yes it works partially, but whenever i change the option in D9 the respective rows should hide & unhide but it is not happening, it runs only if i run some other macro in the sheet (may be the macro is not getting triggered when cell D9 is changed).

Can you look on this further?

Best
Rem0