Major Member
|
執行上還是不行
With ActiveChart.SeriesCollection(1)
.Select
.HasErrorBars = True
.ErrorBars.Select
.ErrorBar Direction:=xlX, Include:=xlBoth, _ <---到這邊還是會出錯!
Type:=xlCustom, _
Amount:="=sheet2!C46:H46", _
MinusValues:="=sheet2!C46:H46"
End With
我試過不是xlBoth的話就可以執行!
不知道為什麼?
__________________
2004 Summer
|