Excel AutoFilter (2000)

Hello. I have a spreadsheet where there is one column with more than 20 unique expressions or values. I want to filter out 5 of these 20 values so only rows with the remaining 15 values remain. I keep getting an error when I use the AutoFilter function. How can I filter out more than just 2 since the custom drop down only allows for 2 values to be filtered out.

Re: Excel AutoFilter (2000)

If you look up the AutoFilter method in the Excel VBA help, you'll see that it doesn't have arguments Criteria3 etc., and you can specify the Operator argument only once. If you want complex criteria, you should create a Criteria range and use Advanced Filter.

Re: Excel AutoFilter (2000)

My question is about the autofilter and what i need it for.

In my workbook autofilter is use to hide row in (column "A") that are 0 values which i have turned off in tools > options so 0's are actually blanks. I activate non blanks for printing only the needed
information on my worksheet.

I run it to problems though when I use my save macro which creates a data file. because it moves a range of cells I am having trouble with moving all the data to the datafile, only the data that is not hidden by the autofilter moves. I do know if there is a way to get all the data instead of just the filtered data. I know that the datafile is properly loaded when autofilter is set to all so its the autofilter that has a charteristic that is troublsome. So I wanted to figure out how to get around it.

I am trying to write a piece of code that says, if autofilter is not set to "all" then msgbox "Price Sheet autofilter is set please expand "All" feature and retry save" exit sub
if the autofiler is set to all then continue into the code.

I am not sure how to do this.

If there is a way to change my data sheet with the autofilter, so that I get all data even when autofilter is on that would be much better