xl2007 problem, points(i).datalabel.top gives overflow
 

I have a macro that modifies the position of chart point datalabels.

When changing the .Top property I get an "overflow" run time error,
but then in debug mode I can step through the offending statement and
don't get the error.

curve.Points(i).DataLabel.Top = curve.Points(i).DataLabel.Top - 3

This very old code that runs in all earlier versions of Excel.
Grrrrrr!

Does anyone know what to do about this?

Thanks,

Brian Murphy

xl2007 problem, points(i).datalabel.top gives overflow
 

On May 2, 9:14 pm, wrote:
I have a macro that modifies the position of chart point datalabels.

When changing the .Top property I get an "overflow" run time error,
but then in debug mode I can step through the offending statement and
don't get the error.

curve.Points(i).DataLabel.Top = curve.Points(i).DataLabel.Top - 3

This very old code that runs in all earlier versions of Excel.
Grrrrrr!

Does anyone know what to do about this?

Thanks,

Brian Murphy


I found a workaround by selecting the chart point, and then using
selection.datalabel.top

Brian