Thread: How to add the direction arrows to lines in an XYscatter

Excel 2007 allows you to format your lines in an XYscatter chart with direction arrows. I cant find the proper method for programming that function in VBA. Can anyone help point me to where this might be documented or tell me the secret.

On a different note:
As a new vba for excel 2007 programmer I've never had so much trouble figuring out how to do simple stuff. I have not found "the" source that documents fully each function/method/object that are used in excel VBA.

Here's one thats been bothering me:
For instance, when you are looping through the columns in a range like this:

dim myselection as range
dim cols as range
for each cols in myselection.columns
{bla bla bla}
next cols

Doesn't the "cols" object have an indexing variable available. I've resorted to adding my own index counter for each loop but surely there has to be an iteration count in the object??

End arrow head

    ActiveChart.SeriesCollection(1).Format.Line.EndArrowheadStyle = msoArrowheadTriangle

No built in index when for each looping. You need to maintain one if required.