View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mrt mrt is offline
external usenet poster
 
Posts: 70
Default 2007: Parent bug in charts

Select a series on a chart

then run

Set Obj = Selection
Do Until TypeName(Obj) = "Workbook"
Debug.print TypeName(Obj)
Set Obj = Obj.Parent
Loop

This never ends on Excel 2007 because strangely, the Parent of the
ChartGroup (which is the parent of Series), is the Series.

This does not happen with previous versions of Excel.

Do you know anyone being the parent of his parents?

MrT