Hi
try disabling automatic calculation before applying the filter

--
Regards
Frank Kabel
Frankfurt, Germany

John wrote:
Second question today.....

Is there a way of using the Application.ScreenUpdating = False method
on AutoFilter?

I've currently got a ten column data range of about 6000 rows and the
AutoFilters takes a long time to work.

All alternative solutions welcome!

Thanks

John