im looking for an easy way VBA to hide specific rows in excell, got three choices in a drop down list and depending of what I choose i want three different set of rows to be hidden.
If i choose "AM" i want to hide rows 30:48
if i choose "PM" i want to hide rows 16:29 and 41:48
if i choose "NS" i want to hide rows 16:40
If i choose "AM" i want to hide rows 30:48
if i choose "PM" i want to hide rows 16:29 and 41:48
if i choose "NS" i want to hide rows 16:40