Macro Code Debug When No Data

Good Morning,

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

Please Login or Register  to view this content.

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

My Hero!! Thank you !