Analyze the logic: Before optimizing the syntax, pay more attention in optimizing the logic.
Release memory from object variables: Whenever we create an object in VBA, we actually create two things -- an object, and a pointer (called an object reference).
We might say, "VB does not use pointers", but it is not true.
I suspect this is because it is redrawing the screen every time a shape is made visible.
This is not necessary, in fact the slide isn't even shown on the screen when this macro is run (it runs on Slide 1 but makes the shapes on Slide 2 visible).
Read them carefully and open new pathways of innovation in creating excel dashboards, reports and automation. Excel calculates page breaks when we perform any of the following operations: o We display a print preview of your worksheet.
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.
o In Microsoft Office Excel 2003 and in earlier versions of Excel, we click Page Setup on the File menu.
o We modify any of the properties of the Page Setup object in a VBA macro.
So streamline your program logic and get the best performance of macros.