I’ve posted several examples of manipulating pivot tables with VBA, for example, Dynamic Chart using Pivot Table and VBA and Update Regular Chart when Pivot Table Updates.
These examples included specific procedures, and the emphasis was on the results of the manipulation.
I’ve seen the threads on this subject that recommend “fiddling with the code” or “calling the code in a subroutine”.
Unfortunately, I have to maintain hundreds of Excel applications each with thousands of lines of code and hundreds of users who are about to migrate to Office 2016, so rewriting is not an option. I wanted to leave a comment but I am not allowed to do so.
VBA Interview Questions and Answers with Examples, macro codes – Download Free PDF File.
Long-running, high-end Excel-based applications that I developed years ago and that run beautifully in Excel 20 look like Amateur Hour in Excel 20 because Application. The screen unfreezes apparently when VBA code copies a preformatted worksheet from the macro workbook into a new workbook, although other circumstances must trigger it as well.The idea is to use the first line near the beginning of your macro, and then use the second line near the end.Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.also with the screenupdating turned off and on, the users will not notice the wkbook being opened at all.just my two cents suggestion glad you like Mr Spreadsheet's solution, but i like the open workbook solution better as it is more flexible.Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately. Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application. is your source for cost-effective Microsoft Excel training.This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.This means that the Excel screen can look like it has "gone crazy" while the macro is running.