Forum Discussion

SamFares's avatar
SamFares
Brass Contributor
Oct 20, 2020

Speeding up VBA execution

Hello,   In the attached excel sheet, i added the "Composite" and "FloorData" tabs to my excel sheet.  Those two tabs are not linked to other tabs in the sheet. When the tabs are in a separate exce...
Macros and VBA
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 21, 2020

SamFares 

Excuse me in advance, but at the moment I can't take the time to look at the whole workbook with the VB code (there are a lot of modules so far).
In spite of the test, here is a way to speed up VBA code.

With Application
.ScreenUpdating = False
.Calculation = xlCalculationManual
.EnableEvents = False
End With

'Dein Code

With Application
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.EnableEvents = True
End With

 

However, you have to weigh up which of these conditions may be necessary for the correct execution of your macro.

 

But I am almost certain that there will be a few more people who will / can offer you an even better solution.
My knowledge compared to some here is very modest (to put it mildly).

 

Sorry that I took your time and couldn't give you a quick solution.

 

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)

 

Resources