Sunday 15 August 2010

Edit Recorded Excel Pivot Table Macro

Title:
Edit Recorded Excel Pivot Table Macro


Video:


Description:www.contextures.com After you record a macro while formatting a pivot table, you can edit the recorded Excel VBA code, to add variables, and make the code more flexible. With a few changes, the code can run on any pivot table, instead of only working on one pivot table. In this video you'll see the steps for recording a pivot table formatting macro, and then editing the recorded macro. Use an index number for the pivot table, instead of a name, and use a variable for the pivot fields.

Published:
16/Aug/2010

No comments:

Post a Comment