cellMatrix.net

Spreadsheet Modeling and Related Topics

Welcome to cellMatrix.net

cellMatrix.net features examples of formulas, charts, and models created with Microsoft Excel. It is indended to be a learning and technical resource for intermediate level Excel users. A special emphasis is placed on the use of VBA for improving processes and the Excel chart object model.

Latest Updates

Quick Notes

Name an Excel Chart with VBA

The code to name an Excel chart using VBA is:

ActiveChart.Parent.Name = "Chart Name"

Sun, 01/10/10 | Comments (0) | Permalink
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:


Tue, 01/05/10 | Comments (0) | Permalink

Tools and Utilities for Excel

The Formula Trace Tool
image

The Formula Trace Tool is designed to make the process of auditing of an Excel spreadsheet, workbook, or series of linked workbooks much easier. Read more . . .