Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Everyone,
coming forward a second time with my problem. I hope more precisely. The following code returns an error message with new Excel. Till that version everything worked fine. Here is the code: CodePosFlag = 11 'Darstellungsreihenfolge und Farbe festlegen If Not IsNull(arrPlotOrder) Then For i = 1 To .SeriesCollection.Count !!!!! .ChartGroups(1).SeriesCollection(arrPlotOrder(i - 1)).PlotOrder = i !!!!!! .ChartGroups(1).SeriesCollection(i).Border.ColorIn dex = arrColorIndex(i) Next i End If The instruction with the exclamation points does not work. Cause we have a lot of these macros there should be another solution than commenting this instruction out. Any idea? Regards Andreas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula in Excel does not work until after I double-click inside c | Excel Discussion (Misc queries) | |||
why doesn't this simple macro work in excel 2007? | Excel Discussion (Misc queries) | |||
Macro does not work inside Excel 2007 | Excel Programming | |||
Excel 2007 - cannot get worksheet change macro to work | Excel Programming | |||
Excel 2007 macro does not work | Excel Programming |