0

Is it possible to clear all filters from an Excel-table, do something else inbetween, and then reapply the filters with the same criteria as before?

Community
  • 1
  • 1
user1283776
  • 19,640
  • 49
  • 136
  • 276
  • See the answers to the same question: https://stackoverflow.com/questions/9489126/in-excel-vba-how-do-i-save-restore-a-user-defined-filter – sybb Jan 14 '18 at 01:41

2 Answers2

1

use like below

 Activesheet.EnableAutoFilter = True

or for Particular range

   Activesheet.Range("A6:R6").AutoFilter = True
manishsingh2061
  • 521
  • 1
  • 6
  • 13
0

This page should show you what you need: Autofilter in VBA

aebailey
  • 195
  • 4