Glad to hear that.

Count series as in,

xlSheet.ChartObjects(1).Chart.SeriesCollection.cou nt

Cheers
Andy

Jim via OfficeKB.com wrote:
thx for the reply, its starting to com on ok now. I just need to find out
how to count series now.

Andy Pope wrote:

Hi,

In the limited testing I can do the code works for me for all 3 series
when the cells are filled.
I could only raise an error if any of the cells in row 10 were either
completely empty or had the formula =NA(). Numbers and even letters was
fine.

Cheers
Andy


The cells get full up and then i send the series values.


[quoted text clipped - 11 lines]

Please help.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info