You can optimize your code by: In this article, I'll show you how to make simple changes to your code to optimize it for speed.I'm using Excel 2016 on a Windows 10 64-bit system, but these tips will work in older versions.STATUS: WORKAROUND Microsoft is aware of and investigating the issue with WPS Office.If you encounter this problem, please repair Office.For the most recent information on this issue, go to Errors loading Excel Solver add-in.Last Updated: November 14, 2017 ISSUE You may have problems closing a workbook in protected view when the Excel file name contains square brackets (e.g., Book1.xlsx).STATUS: FIXED This issue is now fixed in Version 1708 (8431.2079).
The sheet reference is necessary only if you want to run the macro outside of the sheet (Divisions, in this case).
Specifically, built-in updating features and explicit references to the sheet or a range will slow down your code.
Admittedly, with today's fast systems, simple macros won't always need optimization.
STATUS: FIXED Save as Type: Web Page (*htm, *.html).
This issue impacts Excel 2016 in Version 1707 (Build 8326.xxxx).