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

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.