Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am encountering a limit of < 25 array elements when using the following
assignment method: ActiveChart.SeriesCollection(1).Values = thisDataSet where thisDataSet is a declared array variable of type variant. When the array variable has more than 24 elements the above assignment crashes with the message "unable to set the values property of the series class". This array variable always contains numeric data in every element with no empty elements. The assignment works perfectly for thisDataSet of 24 or fewer elements. Is there a better way to assign series values from an array variable? Or, do I have to live with the < 25 array element limit? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding a series of values within an Array | Excel Programming | |||
Finding a series of values within an Array | Excel Programming | |||
Finding a series of values within an Array | Excel Programming | |||
Finding a series of values within an Array | Excel Programming |