Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SeriesCollection error

Status
Not open for further replies.

Colvic

Programmer
Nov 4, 2005
24
0
0
NO
Hi,
Can anyone tell me why this code is not working.
I try to sett the Weight property on lines in a Excel Graph from Access. The Chart have up to 20 lines. It works until lines no 6, then I get a error message: Unable to set the Weight property of the Border class

Here is the code:

Counter = 2
While Counter < objExcelApp.ActiveChart.SeriesCollection.Count
With objExcelApp.ActiveChart.SeriesCollection(Counter).Border
.Weight = xlThick
End With
Counter = Counter + 1
Wend

Thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top