Macro with eayfilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a macro, incorporating easyfilter as part of the macro.

I want the macro to highlight a column, right click on highlighted column
and choose easyfilter, enter '0' in "equal/not equal to" box, select 'not
equal to' button, click 'go' button at bottom of easyfilter, and then stop
the macro.

When I enter the steps, then run the macro, it highlights the column, and
that's it.

How do I get the macro to perform the rest of my request?
 
Hi RPW

That is not possible

But you can open the add-in in the macro like this
Application.CommandBars("Cell").Controls("EasyFilter").Execute
 
OK, well, thanks for taking time to respond!

Ron de Bruin said:
Hi RPW

That is not possible

But you can open the add-in in the macro like this
Application.CommandBars("Cell").Controls("EasyFilter").Execute
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros using Add-Ins 1
Recording a Macro with an Add-In 1
Access Automatically Send a notification email once a record is added 0
Look up match and highlight 1
vba macro that allows insertion of symbols at cursor 0
Simple Macro 1
Macros in Excel 2003 7
How to call Excel add-in macro from a button… 1

Back
Top