Thread: Autofilter / CF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rumkus@hotmail.com is offline
external usenet poster
 
Posts: 22
Default Autofilter / CF

Self answering :

All sheet's events ( except Deactivate) as
Application.Calculation = xlCalculationAutomatic
.........
.........
Application.Calculation = xlCalculationmanual
End sub

Now I can filter even 60.000 rows within milliseconds and my CF works
charmly.