Faster AutoFilter?
 

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

Faster AutoFilter?
 

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

Faster AutoFilter?
 

Hi Frank,

I've tried your sugestion, but I think that as it's mostly text it doesn't
appear to make a big difference.

Thanks

John
"Frank Kabel" wrote in message
...
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

Faster AutoFilter?
 

If it's mostly text, maybe you can apply the filter and then hit a key to
interrupt calculation (I hit the Escape key by habit).

The filtered data shows up nicely, but I get a "calculate" in the statusbar.
(When I'm gazing at the results, excel can calculate what it thinks it needs to
calculate.)

I do the same thing when I do Data|filter|showall.

I interrupt the calculation. I've found that excel calculates lots faster when
there's nothing filtered.



John wrote:

Hi Frank,

I've tried your sugestion, but I think that as it's mostly text it doesn't
appear to make a big difference.

Thanks

John
"Frank Kabel" wrote in message
...
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



--

Dave Peterson