VBA filtering by multiple criteria shows error 1004

[nickamongo]

So I keep getting an error 1004 on this line when I want to filter a drop-down set from cell C4 - any ideas why?




Sub Update()


ActiveWorkbook.RefreshAll
Columns("L:L").EntireColumn.AutoFit
Selection.EntireColumn.Hidden = False
ActiveSheet.Range("$L$4").AutoFilter Field:=1, Criteria1:="FALSE"
ActiveSheet.Range("$C$4").AutoFilter Field:=1, Criteria1:=Array("1. Open", "2. Managed", "In Progress", "Not Started", "Status"), Operator:=xlFilterValues

End Sub

 

[DanteAmor]

So I keep getting an error 1004 on this line when I want to filter a drop-down set from cell C4 - any ideas why?

Sub Update()

ActiveWorkbook.RefreshAll
Columns("L:L").EntireColumn.AutoFit
Selection.EntireColumn.Hidden = False
ActiveSheet.Range("$L$4").AutoFilter Field:=1, Criteria1:="FALSE"
ActiveSheet.Range("$C$4").AutoFilter Field:=1, Criteria1:=Array("1. Open", "2. Managed", "In Progress", "Not Started", "Status"), Operator:=xlFilterValues

End Sub

I tried the code and I have no error.
Where do you have the data in C or in A?
You can put a sample of how your data is in the cells.

 

[nickamongo]

ActiveSheet.Range("$C$4").AutoFilter Field:=1, Criteria1:=Array("1. Open", "2. Managed", "In Progress", "Not Started", "Status"), Operator:=xlFilterValues[/B][/U]

Data is in Column C. I tried canging the field to 3 but that hasn't changed anything.

 

[DanteAmor]

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[nickamongo]

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

https://www.dropbox.com/s/fvuwnvpwihe3xe2/Example VBA.xlsm?dl=0

Now it seems to be failing at the name? (as I'm typing this I think there may be a space in the macro title though...)

 

[DanteAmor]

Apparently you can not filter with VBA when you have data from a pivot table in the same selection.


You will have to copy all the data to another sheet and make the filters with the information on the other sheet.