MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Add Method Series Collection class failed


Posted by Tom Shoemaker on November 28, 2000 3:24 PM

Hi

Could someone please help for the proper format of this seriescollection.add

Sub test3()
Windows("test.xls").Activate
Sheets("MICAP & NMCS").Select
ActiveSheet.ChartObjects("Chart 4").Activate
ActiveChart.SeriesCollection.Add Source:=Sheets("MICAP & NMCS").Range("U6:AF6"), SeriesLabels:=Sheets("MICAP & NMCS").Range("U6:AF6"), CategoryLabels:=Sheets("MICAP & NMCS").Range("U4:AF4"), Replace:=Sheets("MICAP & NMCS").Range("U6:AF6")

End Sub


Posted by Tim Francis-Wright on November 28, 2000 9:06 PM

I think that the replace element should be either True or False--
that's probably causing the error.

HTH