Hello!

I have a pivot table which I have tricked it to autofilter with VBA. The code that I have been using is the following:

Code errors out at: 
Please Login or Register  to view this content.
Like I said, I have used this in the past with NO ISSUES. The only thing that has changed is the number of columns in the pivot table (a few columns were added). The pivot table column range is from Column E to Column AC. I changed the cells for which I want to hide the visible drop down but the code errors out. I don’t know why the code errors out. Anyone have any ideas? Do I need to change something?

"Run-time error ‘1004’: Autofilter method of Range class failed"

Please Login or Register  to view this content.