2003 vs 2007 chart code problem

[clozed75]

Hi

can you tell me why the following lines of code return an error on 2007 & 2010 ?

it works fine on 2003.

1)
ActiveChart.ChartTitle.Text = Ctitle

2)
ActiveChart.SeriesCollection(2).ErrorBar Direction:=xlY, Include:=xlBoth, _
Type:=xlCustom, Amount:=rngINC, MinusValues:=rngINC

With ActiveChart.SeriesCollection(2).ErrorBars.Border
.LineStyle = xlContinuous
.ColorIndex = 15
.Weight = xlThin
End With

strange thing: the second block of code seems to work well when the range "rngINC" is one single cell only.


thank you in advance

 

[Worf]

1) What is ctitle in your worksheet/code ?

2) The following page shows how to create custom error bars with Excel 07:

http://www.andypope.info/tips/tip014.htm