View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mika[_2_] Mika[_2_] is offline
external usenet poster
 
Posts: 9
Default Deleting shape series and trendlines

I'm trying to delete all 20 series and trendlines of a shape. My code
doesn't delete them. What is going wrong?

ActiveSheet.ChartObjects("Shape 1").Activate

For i = 1 To 20
Err.Clear
ActiveChart.SeriesCollection(1).Delete
Err.Clear
Next i

Thanks,
Mika