run-time error '1004': unable to set the ColorIndex property of the Interior class

S

sloth

I've selected a chart and when I try to run the following code inside
of a sub routine, I get the run-time error '1004': unable to set the
ColorIndex property of the Interior class

ActiveChart.SeriesCollection(1).Interior.ColorIndex = 3

Any help is appreciated.
 
S

sloth

I figured out my problem. I was trying to use Interior when I should
have been using Border.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 1004 - Unable to set invertifnegative 7
"Run-time error '1004' 5
Dealing with the error: unable to filter on excel hc home school 0
Excel hangs 1
1004 Error: Unable to set the LineStyle property of the Border class 1
Interop - "Unable to set the Color property of the Interior class" 2
Error 1004 on Range.Text with AutoFilter 3
unable to set the locked property of the range class 8

Top