Disabling Screen Updating function is slowing down my macro

[Martunis99]

Hi guys,

So I built a macro that copies some contents of files to one single sheet based on some cell values.
Since some of these files are extracted from a separate program that executes a few runs on different populations, the amount of data to be copied can sometimes amount to several thousand rows.

In an attempt to make the macro run faster, I put Application.ScreenUpdating = False in the beginning of my program and turned it back on again in the end.
However, when I disable screen updating the macro takes up to 3min to copy over 4 files, and when I don't disable screen updating the macro takes only 30sec to copy the exact same files.

Do you have any idea why in this instance disabling screen updating is actually making my macro slower?

(PS: I don't have any Select or Activates as advised and I tried to assign all my ranges to variables)

Thank you!

 

[Martunis99]

@Gokhan Aycan big oof... Didn't notice that! Thank you so much Gokhan, coming in clutch again!

I will correct it right now!

 

[Yobanlong]

Hi. I know this is an old post, but I have experienced the same thing. I have a spreadsheet that runs simulation by calling a subroutine in a dll (a Fortran code compiled as dll). The dll returns a lot of data which I write into several sheets. In an attempt to speed it up, is set application.screenupdating=False before it writes all the data to the sheets, and then turn in back on. This slows down the execution of the routine with a factor in order 10-20 times. If I comment out the two lines with applicatoin.screenupdating=False and ..=True, then it runs very fast. I have Excel® for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20148) 64-bit.