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
Interop - "Unable to set the Color property of the Interior class" 2
Unable to set the colorIndex Property of the Interior Class Error 3
Excel hangs 1
1004 Error: Unable to set the LineStyle property of the Border class 1
Why unable to set cell's ColorIndex property? 2
"Run-time error '1004' 5
Run Time Error 1004 1

Top