Format pie-chart in VBA

Hi all,

My doubt is probably simple for most of you, but I'm pretty new at this so, better to ask you than keep looking through google.

I've edited a code in word to create a pie chart and format it according the name of the colors using the select case. When this code is run in a excel 2007 it runs pretty good, but once I write the same code in a excel 2003, it gives me a runtime error which say: "Object variable or With block variable not set". below in the code I show where this message appears.

My problem is right in this section, how do I solve this issue in excel 2003, once in excel 2007 is working properly.

Thanks in advance

The code is:

Please Login or Register  to view this content.

use .application before the WorksheetFunction.Index(.XValues, iPoint)