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

Jim via OfficeKB.com wrote:
The cells get full up and then i send the series values.

Andy Pope wrote:

Hi,

Do the range references contain data. Empty cells can sometimes cause
problems when trying to set range references.

Cheers
Andy


Anyone :(


[quoted text clipped - 22 lines]

Please help.



--

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