Helloe,
I'm working with a protected worksheet which comes from an external source and to which I have no password. The sheet I'm interested in has autofilters and I want to ensure that all filters are set to clear (All). I have tried ShowAllData and Selection.AutoFilter Field:=x where x is an integer. I'm sure I have done this but can't find an example - can anybody help please?
I should add that I can set the filters however I like directly on the sheet so is it possible via macros?
Last edited by ij1001; 11-17-2011 at 10:20 AM.
Is anyone able to help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks