Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing properties of a series with no data
I guess one way would be to trap the error.
Regards, Tom Ogilvy "Scott Hodson" wrote in message news:xTvWa.33299$Ne.7969@fed1read03... I'm iterating through my SeriesCollection in my chart and when I try to access any property of a series object that doesn't have any data in it I get "unable to get the <property property of the series class". How can I check to see if a series has any data in it so I can avoid this error? And why would I not be able to access, say, the Name property of a series just because it doesn't have any data yet it still is in the chart's SeriesCollection? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing data in linked Access table | Links and Linking in Excel | |||
accessing data from Access | Excel Discussion (Misc queries) | |||
Access data on spreadsheet without accessing the file?... | Excel Worksheet Functions | |||
Pivot table accessing external data | Excel Discussion (Misc queries) | |||
Accessing List Data | Excel Discussion (Misc queries) |