Hi,

I had to create a script that transfers data out of ascii-files into
Excel-Sheets. After transfering I wanted to create a Chart with that
data using VBA. So far it worked.

Now I'm stuck. I tried to change the color of all the lines to black.

Code:
--------------------

For i = 2 To NewChart.SeriesCollection.count 'First DataSeries is "2"
NewChart.SeriesCollection(c).Select
With Selection.Border
.ColorIndex = 1
.Weight = xlMedium
.LineStyle = xlContinuous
End With
Next i
--------------------


It works, but I have 190 Series in average so it takes about 5 minutes
to change the color. I could draw them with permanent marker on my
screen faster. ;)

So, is it possible to speed that up?

Thank you,

Simon


--
moondark
------------------------------------------------------------------------
moondark's Profile: http://www.excelforum.com/member.php...o&userid=27390
View this thread: http://www.excelforum.com/showthread...hreadid=469118