Tweak to autofilter macro

Hi all,

I had this macro created for me and I would like to alter it a bit so I can re-purpose it...
As is, the macro autofilters to show only the rows/columns that have a vaulue>0 - good. What I don't want it that it will genrerate a pop-up window asking you for the range to filter. I want this to be automatic, set to "C3:AF120". Any help would be greatly appreciated! TIA

Please Login or Register  to view this content.