Applying a super filter using a macro
By juggernutt on Saturday, 18 April 2020
Posted in Kutools for Excel
Replies 2
Likes 0
Views 4.1K
Votes 0
I'm trying to build a macro that automatically applies a Super Filter to my data. However, when I try to record a macro, my application of a saved filter does not appear in the VBA. Is there something I can do, or it that function simply not supported?
Hello,
You cannot access the features of the Kutools for Excel in a VAB code.
Excelfans
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Clear the filters on your sheet or Table.
Turn the macro recorder on (Developer Tab > Record Macro button)
Give the macro a name.
Choose to Store macro in: This Workbook.
Click OK.
Apply filters to one or more columns using the Filter Drop-down menus.
Lewis-H
·
3 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post