VBA to change column chart series colour

I'm currently using the piece of code below to change the colours on a Line Chart when the data is updated. the "rPatterns" variable is a list of the series names with the cell filled in to the particular colour the line chart needs to be.

However I need to replicate this for a Column Chart, but I cannot work out how.

Any help would be much appreciated:

Please Login or Register  to view this content.

Bump.........