Hello,
I'm having a problem with Autofilter in a macro. When I use recorded code, everything works fine.
However, when I try to generalize the code so I can use it when there are more rows in the spreadsheet (see below) I get the beloved Error 1004: Application-defined or object-defined error.Please Login or Register to view this content.
The weird part is I've used the exact same generalized code on another worksheet in the same book and it's perfectly okay.Please Login or Register to view this content.
What am I missing?
Thanks!!
Bookmarks