Use AdvancedFilter instead of Autofilter

--

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


wrote in message ...
Thanks Bob

But this will still only let me set 2 criteria?

Thanks
Paul


On Sep 2, 12:19 pm, "Bob Phillips" wrote:
Do a custom filter in Excel with the macro recorder on, that will get you
started.

--
__________________________________
HTH

Bob

wrote in message

...



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- Hide quoted text -

- Show quoted text -