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
Bookmarks