ExcelBanter - programming custom filter

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - programming custom filter (https://www.excelbanter.com/excel-programming/416399-programming-custom-filter.html)

[email protected][_2_]

programming custom filter

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[_3_]

programming custom filter

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

[email protected][_2_]

programming custom filter

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 -

Ron de Bruin

programming custom filter

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 -

All times are GMT +1. The time now is 05:06 PM.