How do I change referencec/range in a quick way on several chartssheets i a woorkbook
H Henning Aug 4, 2006 #1 How do I change referencec/range in a quick way on several chartssheets i a woorkbook
J Jon Peltier Aug 4, 2006 #2 I designed this utility to work on embedded charts. Perhaps you could adapt it to chart sheets. http://peltiertech.com/Excel/Charts/ChgSrsFmla.html - Jon
I designed this utility to work on embedded charts. Perhaps you could adapt it to chart sheets. http://peltiertech.com/Excel/Charts/ChgSrsFmla.html - Jon
H Henning Aug 7, 2006 #3 Tried your ChgSrsFmla and seem to be the solution I am looking for. However I am not a VBA expert and do not know how to adabt it to work with all Chartssheets in woorkbook "Jon Peltier" skrev:
Tried your ChgSrsFmla and seem to be the solution I am looking for. However I am not a VBA expert and do not know how to adabt it to work with all Chartssheets in woorkbook "Jon Peltier" skrev:
