PC Review


Reply
Thread Tools Rate Thread

Autofilter / CF

 
 
rumkus@hotmail.com
Guest
Posts: n/a
 
      18th Dec 2006
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.

 
Reply With Quote
 
 
 
 
rumkus@hotmail.com
Guest
Posts: n/a
 
      19th Dec 2006
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.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 autofilter change to 2003 autofilter functionality? jonnybrovo815 Microsoft Excel Misc 1 19th Apr 2010 10:05 PM
2007 excel autofilter back to 2003 autofilter? jonnybrovo815 Microsoft Excel Misc 3 19th Apr 2010 08:11 PM
2007 excel autofilter change back to 2003 autofilter? jonnybrovo815 Microsoft Excel Misc 1 19th Apr 2010 05:53 PM
2007 Autofilter worse than 2003 Autofilter =?Utf-8?B?anNreQ==?= Microsoft Excel Misc 9 31st Oct 2007 12:14 AM
How to Sort within AutoFilter with Protection on (and AutoFilter . =?Utf-8?B?Z2libG9u?= Microsoft Excel Misc 1 16th Feb 2006 12:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:16 AM.