The Venerable Sumproduct
A nice post by Daniel Ferry that discusses the sumproduct function can be found at . . . The Venerable Sumproduct.
A nice post by Daniel Ferry that discusses the sumproduct function can be found at . . . The Venerable Sumproduct.
In Time Trials to Measure Minimum and Maximum Values in Charts, Jon Peltier provides five VBA procedures that extract the minimum and maximum values from a chart.
From Pointy Haired Dilbert, a comprehensive list of keyboard shortcuts for Excel.
A nice post from the Contextures Blog that illustrates how to use the TRIM and SUBSTITUTE functions to clean data for list comparisons, etc.
The code to name an Excel chart using VBA is:
ActiveChart.Parent.Name = "Chart Name"
Via the PTS Blog - a series of posts that step through the process of building an Excel add-in:
Key in on the word "enumeration" when searching the Microsoft Knowledge Base for the numbers tied to the VBA chart types.
This Microsoft Knowldge Base article describes the types and subtypes of Excel charts. It also describes what type of data each chart best represents.
This Microsoft Knowledge Base article describes how to trap errors in a macro using various methods.
This Microsoft Knowledge Base article describes how to trap errors in a macro using an "on error" statement.
This Microsoft Knowledge Base article illustrates how to use VBA to remove zero percent labels from a pie chart.