Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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 -


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto filter custom filter stevefromnaki Excel Worksheet Functions 2 December 30th 09 06:23 AM
Programming the filter of a pivot table Jean-Marc P Excel Programming 6 October 5th 07 04:17 PM
programming for advanced filter using external criteria file xxx[_2_] Excel Programming 2 December 21st 05 02:12 PM
Custom Menu Programming Peter Rooney Excel Programming 4 April 20th 05 09:27 AM
What to Charge for Custom Programming DLS[_3_] Excel Programming 3 May 4th 04 11:26 AM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"