New

Applying a super filter using a macro

  Kutools for Excel
juggernutt
  juggernutt
  Saturday, 18 April 2020
  2 Replies
  4.1K Visits
0
Votes
Undo
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?
0
Oldest First  
Excelfans
Excelfans
4 years ago
·
#2113
0
Votes
Undo
Hello,
You cannot access the features of the Kutools for Excel in a VAB code.
Lewis-H
Lewis-H
3 years ago
·
#2114
0
Votes
Undo
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.
  • Page :
  • 1
There are no replies made for this post yet.