Comparing charts after cut and paste
Sorry i probably wasn't very clear with my initial post - i mean if the user
cuts and pastes as per usual, for instance cuts a chart and pastes it to
another sheet in the workbook. I would then want to be able to search for
that chart - but at the moment i cannot see a way of identifying it as the
chart that my original object held.
Here is how I set up my object:
Dim oChartObj As ChartObject
Dim oGridChart As XL3GridChartLib.GridChart
Set oGridChart = New XL3GridChartLib.GridChart
Set oGridChart.ChartObject = oGridChart.Sheet.ChartObjects.Add(200, 3, 280,
175)
the gridchart object then does a bunch of stuff to get all the data it needs
"K Dales" wrote:
Can you show the code where you do the cut and paste (and the object variable
Dim statements would be helpful also)
|