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 gkittelson 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
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