I've got code that I think should be working, but it's not giving the results I expect. I'm using Data Validation to provide lists for my users to select. What I want to do is: If the user selects cell E1 on the ActiveSheet, the value of E1 will be used to autofilter range T2 in Sheet("View2Pivot"). However, if the user selects cell E2 (a merged cell, E2-H2), then that value will be used to autofilter range U2 in Sheet("View2Pivot").
What's happening is, when the user selects E1, nothing happens. When the user selects E2, nothing happens. Then when the user clicks on E1 again (doesn't change anything) the E1 change event triggers. But the E2 change event never happens. My code is below, and I'd sure appreciate some help in understanding this one.