I got 30 different charts in a sheet and I want a macro to select 6 specific charts by name to be copied.
So I need a macro like,
For each charts in activesheet.shapes.range("Chart 1", "Chart 3", "Chart 10",.....)
'To be selected and copied
Any help will be greatly appreciated, thanks!
So I need a macro like,
For each charts in activesheet.shapes.range("Chart 1", "Chart 3", "Chart 10",.....)
'To be selected and copied
Any help will be greatly appreciated, thanks!