have you tried using the formula property?
Paul D

"crossplatform " wrote in
message ...
Worksheets("sheet1").ChartObjects("Chart
1").Chart.SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1"



Well, I'm trying to update the chart's series range. The following
works perfectly:


ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Values = "=Sheet1!R1C1:R20C1"

But I dont want to activate the sheet and the chart :(
Any suggestion?


---
Message posted from http://www.ExcelForum.com/