LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 83
Default code running super slow...

I don't get it... I've created the macro in a copy spreadsheet. Once it was
working I copied it to the template (a read only version). That's where the
slowing down problems began.. I went back to the copy spreadsheet and it is
working fast as it is supposed to be...
The error was because of a typo in calcualtions... Still not changing the
speed...
Any ideas?

"gaba" wrote:

Thanks for your answer, Jim. It is giving me an error... I'm retracing what I
added at the end and it is making it so slow.
Soon as I find what's wrong I'll post it
Thanks a lot,
Gaba

"Jim Thomlinson" wrote:

Tyr turning the calculation off at the start and back on at the end.

Application.calcualtion = xlManual
...
Application.calculation = xlAutomatic

Whenever you toggle these appliation settings it is a good Idea to impliment
an error handler to reset thme in case of a problem.

Hope this works...


 
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
Excel super slow on paste function in 2007 Kevin Excel Discussion (Misc queries) 0 March 15th 10 04:38 PM
File running slow! hoyos Excel Discussion (Misc queries) 6 January 31st 10 08:36 PM
Super slow table array formulas Dylan @ UAFC[_2_] Excel Worksheet Functions 8 December 17th 08 02:42 PM
Excel super slow start, answers? robert morris Excel Discussion (Misc queries) 0 August 19th 07 10:16 PM
Worksheet Running Very Slow Dmorri254 Excel Worksheet Functions 4 February 3rd 05 04:49 PM


All times are GMT +1. The time now is 11:15 PM.

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

About Us

"It's about Microsoft Excel"