Forum Discussion
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...
This could help against this:
Application.Calculation = xlCalculationManual
before the start of the operation and
Application.Calculation = xlCalculationAutomatic
after the operation
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Hi NikolinoDE
I placed the code as shown below at the beginning and end. the values in other tabs will depend on the values in the "composite" tab where the macro is. if i did what you suggested correctly, I didn't see a noticeable difference.
Thanks,
Sam