Hi,
I have used alot of If statement to hide and unhide rows depending on the option selected from several drop down lists. To do this I used "Private Sub Worksheet_Change(ByVal Target As Range)". It works fine but since everytime i enter a value all these if statements run, the program becomes slow.

Is there a more effective and efficient way to do this.

Any help is much appriciated
Thanks