cellMatrix.net

The Venerable Sumproduct

A nice post by Daniel Ferry that discusses the sumproduct function can be found at . . . The Venerable Sumproduct.

Extracting the Minimum and Maximum Values from an Excel Chart

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.

A Comprehensive List of Keyboard Shortcuts for Excel

From Pointy Haired Dilbert, a comprehensive list of keyboard shortcuts for Excel.

Trim and Substitute

A nice post from the Contextures Blog that illustrates how to use the TRIM and SUBSTITUTE functions to clean data for list comparisons, etc.

Name an Excel Chart with VBA

The code to name an Excel chart using VBA is:

ActiveChart.Parent.Name = "Chart Name"

Build An Excel Add-In Via PTS Blog

Via the PTS Blog - a series of posts that step through the process of building an Excel add-in:

• Build an Excel Add-In Part 1 - Basics
• Build an Excel Add-In Part 2 - Added Funtionality
• Build and Excel Add-In Part 3 - Auxiliary Modular Functions
• Build an Excel Add-In Part 4 - Create the Dialog
• Build an Excel Add-In Part 5 - Tie The Code Together
• Build an Excel Add-In 6 - Interface for Excel 2003

Chart Enumeration

Key in on the word "enumeration" when searching the Microsoft Knowledge Base for the numbers tied to the VBA chart types.

Overview of Built-In Chart Types in Excel

This Microsoft Knowldge Base article describes the types and subtypes of Excel charts. It also describes what type of data each chart best represents.

Trapping Errors Within Excel Macros

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.

Macro to Remove Zero Percent Labels from a Pie Chart

This Microsoft Knowledge Base article illustrates how to use VBA to remove zero percent labels from a pie chart.