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...
|