Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default macro does not work inside Excel 2007 #2

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula in Excel does not work until after I double-click inside c raaaabert Excel Discussion (Misc queries) 7 June 8th 17 02:01 PM
why doesn't this simple macro work in excel 2007? ManhattanRebel Excel Discussion (Misc queries) 8 July 19th 08 06:37 PM
Macro does not work inside Excel 2007 Andreas Wiechmann Excel Programming 3 January 25th 08 04:02 PM
Excel 2007 - cannot get worksheet change macro to work [email protected] Excel Programming 5 October 24th 07 04:43 PM
Excel 2007 macro does not work Maritza Excel Programming 1 May 5th 07 12:23 AM


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"