programming custom filter

[paulquinlan100]

Hi

Is there a way in code to reproduce similar results to using
Autofilter - Custom filter?

The reason i want to do this is that i want to filter on more than 2
values (which is the limit when using the built in menu options).

Thanks for any suggestions
Paul

 

[Bob Phillips]

Do a custom filter in Excel with the macro recorder on, that will get you
started.

 

[paulquinlan100]

Thanks Bob

But this will still only let me set 2 criteria?

Thanks
Paul

 

[Ron de Bruin]

Use AdvancedFilter instead of Autofilter

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


Thanks Bob

But this will still only let me set 2 criteria?

Thanks
Paul