Refresh Autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, smart friends

After changing of reference data the autofilter option is NOT refreshed.

Is it possible to refresh the autofilter by activating the (filtered) sheet?

Thanks in advance
 
BKO,

You could use the calculate event: record a macro where you filter the data, and then pop it into
the calculate event, along the lines of

Private Sub Worksheet_Calculate()
Range("E1:G20").AutoFilter Field:=1, Criteria1:="<>0"
End Sub

When any data that is linked into the table is updated, the filter will be reapplied. Copy the code
above, right-click the sheet tab, select "View Code" and paste the code into the window that
appears. Update the range address, field # and criteria....

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Autofilter Arrays 5
Autofilter not allways working Excel 2003 1
How can run a macro ( call a macro) on selection of any filtercriteria? 7
remembering the same filtering criteria 13
Autofilter not grabbing last row 1
Counting Filtered Results Using Autofilter 2
Multiple criteria in autofilter 1
Excel Macro to use cells as a autofilter 0

Back
Top