[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Autofilter / CF

rumkus@hotmail.com

12/18/2006 10:47:00 PM

On my autofiltered sheet I have thousands of rows. Calculation is
manual to filter easily.
But then CF is not working as expected I think it is because of manual
calculation.
How can I trap when a subset of row is selected through filter arrow so
that I could only then change the calculation type to manual ? Any idea
?
Thank you very much in advance.
1 Answer

rumkus@hotmail.com

12/19/2006 10:58:00 AM

0

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.