Hello,

I have a lot of charts in my workbook, some of them are on chart sheets and
some of them on worksheets.

I wrote a sub to change chart color and I need to call it from my macro.

When I have a chart sheet I am passing it as an object and change it to
chart inside my sub. It works with no probelm. My problem is with chart
objects in worksheets.

How can I send/recieve a chartobject as a parameter to the sub ?

Thank you
David Cohen