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..

 

[JNimports]

Just a normal range

 

[RoryA]

Then it should only require something like:

Worksheets("Totals").Autofilter.ApplyFilter