Pplication screenupdating false
A user can select one (or more) reports in vb screen (application is written in vb 6), data from a database are processed and send to the Excel template - then unnecessary worksheets are deleted.
In June 2017 Microsoft issued an update for Excel 2016.
Following the update in June 2017, it is no longer necessary to paste directly after the copy/cut.
Therefore, the copy/cut is more likely to remain active (with the marching ants displayed) after recording a macro.
RELEASE MEMORY ' turn on updates It depends on how much you are actually updating on the screen as part of your code, (i.e.
Screen Updating = b Scrn Upd Exit Sub 'reset them even if you are exiting due to error lbl Error: Application.