Multiple "Worksheet Change" Instructions

Hi all. Very new to VBA but I'm hoping someone can help me out here because I've got stuck...

I want to automatically hide columns based on the contents of a drop down list and then automatically hide rows based on the same criteria. I've worked out how to do either one on its own but can't seem to combine the 2 without error. I've pasted the code I'm using below. Each section (that starts "Private Sub Worksheet...") works on its own but not when I try do both at the same time (as below). B2 hold the contents of a drop down list.

Any help would be much appreciated!

Please Login or Register  to view this content.

What about trying to write a unique macro working on columns and rows to hide at the same time?

Thanks, but not sure what you mean???

Awesome, thanks Rorya.

Is there a way to amend it so that when I select "All" in the B2 drop down list that columns and rows get UN hidden?

I meant exactly what rorya has written

Perfect - thanks guys.