[SOLVED!] VBA Excel reset filters without removing them

VBA in Excel. You want to reset the filters without removing them from the spreadsheet. Just like clicking on the Select All.
If ActiveSheet.AutoFilterMode = True Then
ActiveSheet.AutoFilterMode = False
End If
Rows("1:1").Select
Selection.AutoFilter

Just a very important note: Selection.AutoFilter works as a switch. Call it twice.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s