VBA Autofilter Problem

[systematic]

Hi folks,

I'm trying to manipulate a number of large datasets (web logs) to eliminate content I am not interested in. This data is split over 18 spreadsheets, each containing around 900k rows, with column 'A' containing a long text string.

I've created the following filter expression in VBA -

Please Login or Register  to view this content.

This runs without error, however is only filtering around 3,000 records from the 900k in the worksheet (not the expected 90-95%). Am using Excel 2010.

Any thoughts? I think it is only filtering on the last value in the array "/company"?

Cheers

Rob

[AB33]

Like AND and OR OPERATORS in filter you can use two with asterisks (Wild card) ONLY. So, the code works, but only filter the first two with *.

[:) Sixthsense :)]

Insted of Operator:=xlAnd use Operator:=xlFilterValues