Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 23rd 07, 10:59 AM posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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


  #2   Report Post  
Old November 23rd 07, 02:33 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 183
Default Strange behaviour - very slow after filter

try putting the calculation on manual before executing the macro
With Application
..Calculation = xlManual
End With

then back on automatic
With Application
.Calculation = xlAutomatic
End With

--
caroline


"Dan" wrote:


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

  #3   Report Post  
Old November 23rd 07, 02:51 PM posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 866
Default Strange behaviour - very slow after filter

Thanks, but it is still very slow. The only way around I could find so far is
to remove the filter.
Dan

"caroline" wrote:

try putting the calculation on manual before executing the macro
With Application
.Calculation = xlManual
End With

then back on automatic
With Application
.Calculation = xlAutomatic
End With

--
caroline


"Dan" wrote:


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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange if(***) behaviour? Excel 2003 - SPB Excel Discussion (Misc queries) 6 August 6th 06 05:34 PM
Strange VBA Behaviour Ricko Excel Programming 0 July 28th 05 07:53 AM
Strange behaviour Edgar Thoemmes Excel Worksheet Functions 1 February 8th 05 04:20 PM
Strange behaviour in VBA Help Michael Singmin Excel Programming 4 June 4th 04 07:06 PM
strange behaviour Patrick Molloy Excel Programming 0 September 4th 03 07:51 AM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017