Runtime Error '91' Object variable or With Block variable not set.

**pink** · 02-13-2009, 04:44 PM

Hello,

Thanks for helping.

I'm getting a
Runtime Error '91'
Object variable or With Block variable not set.
when I run a button that creates a pie chart from a set of data:

When I hit debug, this is what highlights:
ActiveChart.ChartType = xlPie

Please Login or Register  to view this content.

Do you have any idea what is wrong?

Thank you.

**Richard Schollar** · 02-13-2009, 06:05 PM

I may be wrong here as I rarely do anything with charts but sometimes the order of code can cause problems when manipulating charts so I suggest you change the two lines around:

Please Login or Register  to view this content.

**pink** · 02-15-2009, 03:08 PM

Sorry about that. Edited.

**shg** · 02-15-2009, 03:12 PM

Pink,

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with Code Tags.

**pink** · 02-15-2009, 03:29 PM

Thank you, Richard.

I tried what you suggested, and the error still exists, and instead of the

Please Login or Register  to view this content.

being highlighted, it is the

Please Login or Register  to view this content.

Hmm.

**Andy Pope** · 02-16-2009, 06:01 AM

It may help if you posted example workbook as your original code worked fine for my test data.

**pink** · 02-16-2009, 02:52 PM

Originally Posted by Andy Pope

It may help if you posted example workbook as your original code worked fine for my test data.

Sure, thanks.

I have to mention that this works for me as well ( Excel 2003 ), but I have a friend who gets this problem when she uses it (2007)

I've attached the worksheet. It is the macro for "Chart Earnings" that doesn't work properly for her, the other two buttons work. And they have virtually the same code...

**Andy Pope** · 02-17-2009, 05:25 AM

The code fails because no chart is added when the selected range includes the Name cell.

This fails but does not raise an error

Please Login or Register  to view this content.

try this revision

Please Login or Register  to view this content.

**pink** · 02-17-2009, 02:24 PM

That will probably do it, thank you.

I'll have my friend run it and will post back with results shortly.

Thank you.

edit: it works perfectly. Thank you very much.

Solved.