The specified value is out of range

[Edski]

Hi,
I'm using the new office 2007 Beta version and I am having problems with VBA.

Dim aChart As Chart
    Set aChart = ActiveChart
    aChart.Shapes.AddTextbox msoTextOrientationHorizontal, 1, 1, 100, 100

I get the following error: "The specified value is out of range", highlighting the last line above. This used to work in Excel 2002. I've been checking out the Microsoft site and they seem to have chnaged quite a few things and are also having problems with bugs, such as the "Chart.PlotArea.Interior.Pattern" property.

Any ideas?

 

[SkipVought]

Hi,

I inserted a chart and ran your code without error.???

This might help...

Charts & VBA faq707-4811

Skip,

_[red][/red]

 

[Edski]

SkipVought,
Are you using Office 2007?

 

[TonyJollans]

If you are using the Beta version of 2007, it may have all sorts of problems. It is about to expire and I no longer have it installed but I can't reproduce your problem on the RTM version.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association