CODEWITHSUNDEEP
vbaexcel
user1283776
user1283776

Reputation: 21764

Clear all filters from an Excel-Table and reapply it?

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?

Upvotes: 0

Views: 1768

Answers (2)

manishsingh2061
manishsingh2061

Reputation: 521

use like below

 Activesheet.EnableAutoFilter = True

or for Particular range

   Activesheet.Range("A6:R6").AutoFilter = True

Upvotes: 1

aebailey
aebailey

Reputation: 195

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

Upvotes: 0

Related Questions