macro for refreshing filters

[megaman666]

is there a way to program a macro for a refresh button that will update a worksheet based on applied filters? Ie, to have the current filters applied to take into account changes made since workbook was last opened/filters manually applied?

 

[BiocideJ]

I believe the code you are looking for is.

assuming the autofilter is on the current sheet (otherwise modify the ActiveSheet object to refer to the sheet you want)

ActiveSheet.AutoFilter.ApplyFilter