Good Morning,

I am currently using the following code to change the bar color on a stacked graph.

ActiveSheet.ChartObjects("Chart 12").Activate

ActiveChart.SeriesCollection(1).Interior.Color = RGB(255, 255, 255)
ActiveChart.SeriesCollection(2).Interior.Color = RGB(235, 152, 52)
The issue i am having is if i choose a range that has no records, the code debugs as it has nothing to colour.

Is there a formula (or that of the like) to say somthing along the lines of IF Blank then do nothing else above code?

Or a simpler way? Any help pwould be greatly appreciated.

Thanks
Ross