View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default Strange behaviour - very slow after filter


I have a sheet with some macro - all working fine.
BUT... As soon that I use (even once) the autofilter then all the macro
especially the ones that change things on the screen work very very slowly,
even when I remove the filter it stays like that, until I reopen the sheet.
Application.screenupdating = false/true did not solve the problem - just
postponed it.

Any idea?

Thanks
Dan