View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Martin Martin is offline
external usenet poster
 
Posts: 336
Default 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)