RodrigoFinguer
Board Regular
- Joined
- Jun 13, 2017
- Messages
- 75
Hello,
I used to filter a sheet using a pivot table and a range with formulas.
In this example I use:
Here is my sheet:
From column A to D is my pivot table, and columns E and F there are formulas that I need to filter the value 0 in the F column.
Every time I try to run the code I get error 1004, but it worked fine days ago.
I used to filter a sheet using a pivot table and a range with formulas.
In this example I use:
VBA Code:
ActiveSheet.Range("A:A, F:F").AutoFilter Field:=6, Criteria1:="0"
Here is my sheet:
From column A to D is my pivot table, and columns E and F there are formulas that I need to filter the value 0 in the F column.
Every time I try to run the code I get error 1004, but it worked fine days ago.