| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with eayfilter
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro with eayfilter
Hi RPW
That is not possible But you can open the add-in in the macro like this Application.CommandBars("Cell").Controls("EasyFilt er").Execute -- Regards Ron de Bruin http://www.rondebruin.nl "RPW" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro with eayfilter
OK, well, thanks for taking time to respond!
"Ron de Bruin" wrote: Hi RPW That is not possible But you can open the add-in in the macro like this Application.CommandBars("Cell").Controls("EasyFilt er").Execute -- Regards Ron de Bruin http://www.rondebruin.nl "RPW" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
