Error 91 with Macro that Sets Fill and Line Color in Pivot Charts

Greetings

I have a macro that sets the fill and/or line color of 4 different charts to either red, blue, or green.

I recorded the macro as I performed the steps that I would take and this is the code that resulted.

Please Login or Register  to view this content.

But now I'm getting a Run-time error '91': Object variable or With Block variable not set.

It highlights the first line of code "ActiveChart.FullSeriesCollection(1).DataLabels.Select" when I attempt to debug.

I would really appreciate finding out what I'm missing here.

Thanks a bunch in advance.

aww fudge...I didn't notice that, and also, it is not....how do I write the code if I simply want the fill and line color of the charts on a specific sheet to be the way they're coded above?

this would have to work if someone is opening the workbook for the first time and or tabbing between sheets

the whole purpose of this code is because excel insists on reformatting my charts with different colors

Quick update:

That code, humdingaling, worked somewhat well but Excel keeps fighting me on the fill and line colors.

I'll keep at it and post the solution should I come upon it.

Thanks for the help.