Excel 2007 : Excel 2007 VBA error

**carmennorman** · 07-07-2008, 11:22 AM

Hello

I hope someone can help me. I have a very simple piece of code, that works perfectly in Excel 2003, but my users have now upgraded to 2007 and the code doesn't work. I keep getting an error: Object variable not set (Error 91). But as far as I can see I have declared everything.

The code is:

Please Login or Register  to view this content.

The error message appears the first time I am using the variable for the activechart. Very confused

, like I said it works in 2003. What do I need to do to get it working in 2007? Please help

**Andy Pope** · 07-07-2008, 11:29 AM

The code fails because there is current no active chart.

you can check before executing code

Please Login or Register  to view this content.

Do you have any other code that may cause the activechart to lose focus before reaching the code you posted?

**carmennorman** · 07-07-2008, 11:37 AM

Thanks Andy

The user is prompted to select the chart, because the sheet has loads of charts they need to select the chart that needs updating before they run the macro. I already have an error in place...

The full example of the code is:

Please Login or Register  to view this content.

**Andy Pope** · 07-07-2008, 11:44 AM

So how are they starting the macro?

Your example, for me, displays a error message as expected.

Can you post example workbook where the untrapped error is raised?