Code Updates - February 18 2011
A code module for working with document properties, and aoption often better than using hidden sheets and named ranges:
http://vba.wikidot.com/document-properties
A small exercise for a graduate BI student, to show how to use VBA to sum arrays, in this case iteratively or mathematically:
http://vba.wikidot.com/vba-array-summation
Links related to modifying Excel 2007 pivot charts:
http://vba.wikidot.com/pivot-charts-copy-and-repoint
http://vba.wikidot.com/extract-pivot-datasource-excel-2007
Two workbooks for evaluation programming, one specifically for VBA:
