Is it possible to create a custom collection and add Chart Objects to it?
I know their is an existing collection in the object model based on ActiveSheet.ChartObjects which I can loop through.
But I want to group two sets of charts (10 charts total but two groups of 5x charts) on a sheet so that I can manipulate the formatting via VBA.
So I want to create two custom collections, add the relevant charts to each collection. loop through each collection and then undertake separate VBA formatting for each collection.
Thanks
I know their is an existing collection in the object model based on ActiveSheet.ChartObjects which I can loop through.
But I want to group two sets of charts (10 charts total but two groups of 5x charts) on a sheet so that I can manipulate the formatting via VBA.
So I want to create two custom collections, add the relevant charts to each collection. loop through each collection and then undertake separate VBA formatting for each collection.
Thanks