ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Passing chartobject as a parameter to sub (https://www.excelbanter.com/excel-programming/340756-passing-chartobject-parameter-sub.html)

David Cohen

Passing chartobject as a parameter to sub
 
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







All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com