excel
Get flash to fully experience Pearltrees
tips
perl
basic
The CommandText Property The CommandText property holds the SQL statement that defines the table in an External Data table. This property holds a String data type which means it can be changed or manipulated like any other text.
Querying External Data in Excel
Excel's object model has a serious flaw: There is no direct way to to use VBA to determine the ranges used in a chart. This tip contains a useful class module that can simplify the task of manipulating chart's using VBA. Background Information The Series object is contained in a Chart object. The SeriesCollection is a collection of Series objects for a particular Chart object. If a chart plots two data series it will have two Series objects.
Excel Developer Tip: A Class Module to Manipulate a Chart SERIES