Chart.Labels.Add function doesn't work in excel 2007

Hi

I am new to macros. We are using some macros which is running perfectly fine in excel 2003 but in 2007 it is throwing error in following function. So can you please help on this.

The error comes at line
Set objLabe2 = cht.Labels.Add(dblXPosition, dblYPosition, intLength, intHeight)

in following function (this line don't create any error if excel 2003 installed on my machine but if excel 2007 installed then it says unknown exception occured in the system.

Please Login or Register  to view this content.

Try changing ...

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

objLabe2 is never declared anywhere, but objLabel is. And, the next line uses objLabel, not objLabe2.

There seems to be other potential issues. Like ...
* mdblXmin, mdblXmax and mdblYmin, mdblYmax never get defined (???), and ...
* ActiveSheet.ChartObjects("cht").Activate ... failed for me. I commented it out; and it worked. I don't think you need it anyway.
... Regards, sauerj

Hi

Thanks for reply. I am sorry mistakenly I have typed 2 there but it is objLable only and in Debug mode I am getting all the values withoot any problem. Moreoverly it is working without any problem if Excel 2003 installed machines. But now all our machines are installed with Excel 2007. Since then it is theowing error at this place.

Thanks
Krishna

Krishna, when you are replying to a post directly above, please do not quote. It just creates clutter. Thanks.

In xl2007 you will need code like this

Please Login or Register  to view this content.