I have written a considerable number of macros for Microsoft Word running on Windows 10.
One macro in particular takes lines of text from a Word.Table in one Word.Document, copies them to Word.Paragraphs another Word.Document, and formats them with various Word.Styles.
The use case is that the macro is writing a contract for me, from a table of template clauses.
Normally, this runs quite slowly, as there is a lot of work going on underneath, both in selecting template clauses, and formatting; and I have optimised later when possible.
However, by chance I found that if I held down the CRTL + ALT key whilst the macro was running, the speed seemed to increase by 2x or more.
I observed this through the speed by which Debug.Print messages appeared when tracking the progress of the macro, and anecdotally have seen the same effect on other macros I have written.
It seems an unlikely quick win or free lunch.
Has anyone else encountered this for their own macros, or am I imagining things?