Hello everyone
I've compatibility problem, macro works in Excel 2007 and higher but doesnt in 2003. i've problem with code below, error occurs with Operator, when i delete this string it doesnt work properly. Any help would be appreciated
Please Login or Register to view this content.
Last edited by Leith Ross; 10-16-2015 at 11:24 PM. Reason: Added Code Tags
Hi lewap90
Welcome to the Forum!!!
Filtering with an array was introduced with Excel 2007. Prior to 2007 The custom AutoFilter only allows for up to 2 Criteria at a time.
Here's a link to a possible workaround.
http://www.techonthenet.com/excel/filters/advanced1.php
Last edited by jaslake; 10-14-2015 at 05:21 PM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thanks for the quick response jaslake
i 've managed to filter by range using advanced filter in VBA but i dont know how to filter this case:
In 2nd column i have data like 1, 2, 3, 4, 5 and so on and additionaly i have "-" and "_"
numbers 1,2, 3, 4, 5 represents active positions
"-" and "_" represents inactive ones
In 3rd column i have data like DW234SG, DW861KT and so on
My criteria Range is DW234SG, DW861KT for example
How to filter data to gather only active and only DW234SG, DW861KT at the same time?
Hi lewap90
Can't do much with pictures. If you'll attach a sample file (with existing Code) I'll look at it.
Here you are
Additional information for you:
information from criteria range can occur as active and inactive in the same table and i need to filter active firstly and then filter by required information
Hi lewap90
This Code in the attached creates a new Worksheet with only the Active items and then Filters that new Worksheet based on the Criteria. It's the best I can come up with at the moment.
Please Login or Register to view this content.Please Login or Register to view this content.
Awesome job works like a charm
You're welcome...glad I could help.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
If this resolves your issue please mark your Thread as SOLVED.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks