Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
seriescollection(name) not working in excel 2007
Hi,
I've got some VBA code running in some VBScript classes that works in Excel 2000 and 2003 (or excel versions 9 and 11) that identifies a series object in the following way (assume taht oMyChart points to a valid chart object): set oSeries = oMyChart.SeriesCollection("MyChartSeries") msgbox oSeries.name I know that "MyChartSeries" is a valid series name as the following code tells me (works in 2000,2003,2007): for each oSeries in oMyChart.SeriesCollection msgbox oSeries.Name next Is there something wrong with the way SeriesCollection works on 2007? I can't believe there is something I'm doing wrong here as it does work in the other versions just fine (famous last words I know...). I can not find any examples on the net where a name is used for index. Signed, "In VBA hell..." |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
F2 Key not working in Excel 2007 | Excel Discussion (Misc queries) | |||
click right not working in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
excel 2007 Seriescollection.Add bug | Excel Programming | |||
Excel 2007 links not working | Excel Discussion (Misc queries) |