VBA Code to Automatically Re-apply Filter

[JNimports]

Hi - does anyone have a working VBA code to automatically reapply a number filter on greater than 0? I have tried 3 or 4 codes that I found by searching but none of them actually seem to do anything! It is possible that I'm doing something wrong in the applying of them though..

 

[Paul Ked]

Most things are possible, and in answer to your question about applying code... you probably are doing something wrong!

What is the first number filter? What have you tried?

 

[MARK858]

Can you explain exactly what you mean by "automatically reapply", please explain your process?

Can you also let us know the range of your data and the range that you are applying the filter to (and the sheet name if there is any chance that you could be on any other sheet when running the code) as it is a bit difficult writing any code without them

 

[JNimports]

That is a very distinct possibility!

The filter is greater than 0. When a value is entered in one of the first 3 tabs, I want the filter on the fourth tab to update and show the corresponding row, it is pulling the value through with a VLOOKUP.

 

[JNimports]

The tab with the filter is called 'Totals'. The range is E6 to E367.

Thanks!

 

[MARK858]

Try

If Worksheets("Totals").FilterMode = True Then Worksheets("Totals").FilterMode = False
Worksheets("Totals").Range("E5:E367").AutoFilter 1, ">0", xlAnd

Please note that it won't run automatically in a Worksheet_Change or a Worksheet_SelectionChange event as these don't fire with a change of formula result.

 

[RoryA]

The autofilter object has an ApplyFilter method which will reapply whatever filters are currently set.

 

[JNimports]

Try

If Worksheets("Totals").FilterMode = True Then Worksheets("Totals").FilterMode = False
Worksheets("Totals").Range("E5:E367").AutoFilter 1, ">0", xlAnd

Please note that it won't run automatically in a Worksheet_Change or a Worksheet_SelectionChange event as these don't fire with a change of formula result.

I must be doing something wrong as it is not working, when I enter a value in another tab the fourth tab stays filtered..

 

[JNimports]

The autofilter object has an ApplyFilter method which will reapply whatever filters are currently set.

Sorry, not sure what this means!

 

[RoryA]

Is your data in a table, or just a normal range?