M
Matthew Dodds
Back in December musa.biralo posted asking about why copy chart was so
slow.
I've just been working with this and found that while using
activesheet.ChartObjects(1).copy followed by a .paste within a with
worksheets clause is indeed very slow (~3 seconds), the exact same
outcome can be acheived using chtObj.chart.ChartArea.Copy followed by
the same .paste within a with worksheets clause ... but occurs without
perceptible delay. It appears that Excel recognises the need to
provide the chartObject object to accommodate the pasted ChartArea,
thereby removing the need to copy/paste this object along with the
ChartArea itself. It similarly appears that it's the copy/paste of the
chartObject object that takes the time.
Matthew
slow.
I've just been working with this and found that while using
activesheet.ChartObjects(1).copy followed by a .paste within a with
worksheets clause is indeed very slow (~3 seconds), the exact same
outcome can be acheived using chtObj.chart.ChartArea.Copy followed by
the same .paste within a with worksheets clause ... but occurs without
perceptible delay. It appears that Excel recognises the need to
provide the chartObject object to accommodate the pasted ChartArea,
thereby removing the need to copy/paste this object along with the
ChartArea itself. It similarly appears that it's the copy/paste of the
chartObject object that takes the time.
Matthew