ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Accessing properties of a series with no data (https://www.excelbanter.com/excel-programming/273326-re-accessing-properties-series-no-data.html)

Tom Ogilvy

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?






All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com