This macro was working just fine, now it generates an error on the line in red.
Please Login or Register to view this content.
Any hints, tips or examples are welcome.Run-time error '1004':
AutoFilter method of range class failed
This macro was working just fine, now it generates an error on the line in red.
Please Login or Register to view this content.
Any hints, tips or examples are welcome.Run-time error '1004':
AutoFilter method of range class failed
Last edited by Rick_Stanich; 01-20-2010 at 10:38 AM.
Regards
Rick
Win10, Office 365
Is the sheet protected? Is there already an autofilter in place elsewhere?
Remember what the dormouse said
Feed your head
Your always spot on.
I recall now I had interupted the macro, thus it left the autofilter on. I simply refused to see the autofilter drop down button on that column for some reason.
It always amazes me how the obvious is so easily overlooked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks