variable series collection in a chart

[neunelfer]

Hi there,

I'm not very experienced in programming VBA, but I have to..
My problem is, that I want to send a variable to a series in a chart..
and I tried it like this :

Worksheets("L CDMBAN1&quot.ChartObjects(1).Activate
ActiveChart.PlotArea.Select
'MsgBox ("=L CDMBAN1!R3C" & iColData & ":R" & intSweep & "C" & iColData)
ActiveChart.SeriesCollection(iColDataInt).XValues = "=L CDMBAN1!R3C" & iColData & ":R" & intSweep & "C" & iColData


I always get a $#@% error, and tried a ton of changes, but nothing helps.

Please excuse my bad english, I'm german

 

[johnwm]

You may get better answers in the VBA forum (forum707) or the MS Office forum (forum68)

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'