Why does this following macro not work in 2010 but works in 2007?

Why does this following macro not work in 2010 but works in 2007?

Please Login or Register  to view this content.

How does it not work?

Any errors?

Incorrect results?

I've only had a quick look at it but I can't see anything 'version specific' that could cause problems.

In 2007 it autofilters correctly but in 2010 it autofilters and somehow doesn't find any matches so it doesn't do anything

I know the filtering in 2010 did change but as far as I knew you could still
use the filtering from earlier versions and it would work.

Is it possible there's a problem with the data?

Any chance you could upload a workbook with some sample data?