| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003) | Charts and Charting in Excel | |||
| Problem with Datalabel in Stacked bar charts | Charts and Charting in Excel | |||
| A curious OVERFLOW problem | Excel Programming | |||
| Problem with overflow | Excel Programming | |||
| Overflow Problem | Excel Programming | |||
Hybrid Mode
