View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin Martin is offline
external usenet poster
 
Posts: 336
Default Comparing charts after cut and paste

Hi,

I am currently wrting a part of an add-in that dynamically charts data
within a worksheet which changes depending on a users actions. Everything
works fine until the chart object is cut and pasted. When this happens my
object loses the chart object and there seems to be no way of identifying the
newly pasted chart as being the same as the one that was cut. The chart name
is changed (for instance from "chart 1" to "chart 2"), so that can't be used
as a comparison, and i can't find any other properties which would be
suitable.

Anyone got any suggestions?

Many Thanks
Martin