Hide Page Breaks: When we run a Microsoft VBA macro in a later version of Microsoft Excel, the macro may take longer to complete than it does in earlier versions of Excel. Hence, turning off events will speed up our VBA code performance.In the Visual Basic Editor, go to the Tools menu, and click VBAProject properties. Sub Select Web Page To Open() Dim The Page As Variant The Page = _ Application.
Screen Updating-Property does not work properly in Excel 2016 / Win 10. The screen is updated after each step in VBA, although the Screen Updating is set to False. It would be nice to have this bug fixed as quickly as possible, since I have hundreds of Makros who depend on this property.but in the informal testing I've done, I've found that Visible = False makes Word work roughly 15% faster than Screen Updating = False does on identical tasks.That's about 1 second for every 7-not a trivial amount if your job runs longer than that. Chief among them is that repagination routines don't work when Word is invisible.On the eve before Christmas, I'm writing this article on VBA code optimization for my blog readers as a gift. For example, a macro that required several seconds to complete in an earlier version of Excel may require several minutes to complete in a later version of Excel.It contains both the knowledge and good practices which if followed and used effectively then it might put you in elite category of excellent VBA programmers. This problem may occur if the following conditions are true: * The VBA macro modifies the properties of many rows or columns.