I have data that I export to excel which is used by a chart that has already been set up. The problem that I am having is with the color of the bars. The user can specify what colors to use with a Common Dialog Box. I get a 1004 error in the when I try to change the bar colors with this line:
ActiveChart.SeriesCollection(3).interior.colorindex = &H00FF0000&
What is the right way to change the colors of the bars based on the user's input from the Common Dialog Box??
Thanks in advance!