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
