Hide/Show rows based on drop down list

Marvin P

Ok in the VBA you have "If Not Intersect(Target, Cells(4, "G")) Is Nothing Then" but in my sheet that Im going to use this on the Cells E41:E42 are Merged and that is where the Data Validation list is located. I have changed the code from If Not Intersect(Target, Cells(4, "G")) Is Nothing Then to If Not Intersect(Target, Range("E41:E42")) Is Nothing Then and cant get it to work. I cant just do If Not Intersect(Target, Range("E:E")) Is Nothing Then Because I will have Validation on column E3 Rows 2, 15 28 Can this still be done?

Here is the sheet so you can see what I'm trying to do.. So if the Data Validation in Cell E41:E42 is Blank it would hide Rows 42:48 but any other selection it would show Rows 42:48. Disregard the conditional formatting Ill fix that once this problem has been fixed LOL

Thanks Again!