Re: Excel slowing down....
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Tue, 21 Aug 2007 08:12:37 -0500
If you can see the pagebreak dotted lines, then excel will slow down.
If you're in View|Page break preview mode, then excel will slow down.
Turning off .screenupdating and changing the .calculationmode to manual may help
speed things up:
Option Explicit
Sub testme()
Dim CalcMode As Long
Dim ViewMode As Long
Application.ScreenUpdating = False
CalcMode = Application.Calculation
Application.Calculation = xlCalculationManual
ViewMode = ActiveWindow.View
ActiveWindow.View = xlNormalView
'your code here
'put things back to what they were
Application.Calculation = CalcMode
ActiveWindow.View = ViewMode
Application.ScreenUpdating = True
End Sub
Darin Kramer wrote:
Hi Guys,
After running several complex macros Excels perfomrance noteably drops.
Im assuming its because the cache is full of previously copied and
stored information..(which may or may not be the only reason...)
Is there a way to force clear this at the end of running some VB, in an
attempt to maintain a consistent speed.
(PErformance increased if you quit out of Excel and then start again...)
Thoughts...?
thanks!
Regards
D
*** Sent via Developersdex http://www.developersdex.com ***
--
Dave Peterson
.
- References:
- Excel slowing down....
- From: Darin Kramer
- Excel slowing down....
- Prev by Date: Lower case "a" in "application"
- Next by Date: Re: Changing linked cell runs ComboBox code
- Previous by thread: Excel slowing down....
- Next by thread: COUNTA
- Index(es):
Relevant Pages
|
