PDA

View Full Version : Solved: Excel 2007 vba - Filter criteria problem



chamdan
05-05-2012, 10:09 PM
Hi,

I :banghead: trying to resolve this issue and could not.

I want to filter an excel worksheet with the following criteria.

I want based on certain selection that the filter will extract data that have in column AC starting from AC4 to AC2500 the following codes:

Filter only the ones that have a code as: 002|* and all the sub-elements such as 002| can have 100's of sublevel that looks like 002|010 or 002|020 and so on then 004|* or codes that have 006|* and maybe 009|*

Has anyone had any problem with the filter where the filter gets you no data extracted when the criteria eceeds 2 selections. Because with 2 selections I have no problem but If I add one more then nothing is extracted.????? I have used arrays as criteria and did not work an example is below:


Range("AC3" & ":" & "AE" & LastRow).AutoFilter _
Field:=1, Criteria1:=arrCriteria, Operator:=xlFilterValues

where Criteria is an Array of the selected criteria.

Your help is needed.

Thanks in advance.

Chuck

chamdan
05-06-2012, 12:27 PM
:thumb Finally got it resolved using field=2 and Operator=xlFilterValues

Thanks

Chuck