Tips to speed up VBA with several workbooks open.

H

HammerJoe

I was wondering if there are any tips out there to allow faster
execution of VBA with several workbooks open?

For example, I have a macro that deletes some cells contents in five
different sheets in the same workbook.

With no other workbooks open it takes 2 seconds to complete.
With other workbooks then it takes more than 10 seconds to complete.
This is just an example.
Obviously the fact that there are other workbooks open has an impact
on the execution.
Any way to speed up this?
 
T

Tim Williams

Have you tried turning off screenupdating and setting calculation to manual
?

Tim
 
H

HammerJoe

I am using screenupdating all over the place yes...
Manual Calculation not so much, I will give it a try to see if it
makes a difference.
 
H

HammerJoe

Why does it slow so much with several workbooks opened with no links
between them?
 
Y

ytayta555

Why does it slow so much with several workbooks opened with no links
between them?
Click to expand...

Maybe because for every change in ActiveWorkbook are recalculated all
opened
wbooks ...it's an ideea , I'm not shure.

I has problems with delete of cell contents and I found that
Range("...")ClearContents
work faster than Range("...").Delete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to Password-required-to-open workbooks 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Who is linking to my file? And what files am I linking to? 1
How to open workbooks in different Excel? 2
VBA - ThisWorkbook 4
VBA EXCEL COPY BETWEEN WORKBOOKS 2
Major help needed!!! 2
Macro that adds up the sheets of similar workbooks 3

Top