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!
Bookmarks