View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mathieu mathieu is offline
external usenet poster
 
Posts: 3
Default Adding HPageBreaks after a Chart

Hi there,

I do not quite understand how I can add a HPageBreaks after a Chart.
HPageBreaks takes as parameter a Cell, while adding a Chart takes an
absolute position:

for ...
wc2 = ws.ChartObjects().Add(Left=left, Width=width, Top=top,
Height=height)
ws.HPageBreaks.Add(Before=ws.Cells((i+1)*20,1) )

Is there a way to Add a Chart on a particular Cell instead of an
absolute position

Thanks,