Typemismatch when duplicating graph
Thank you Andy for your prompt answer. I was not so quick though...
I tried your suggestion but it didn't work. I got the error:
Run-time Error '1004':
Method 'ChartObjects' of object '_Worksheet' failed
I admit I don't understand the setting of the graf variable quite
well. Doesn't list.ChartObject() require an index and
list.ChartObjects is a set, isn't it?
In any case, what is to be done? I can't believe I'm the first one in
the world who encountered this bug. Can the people at Microsoft
somehow be alerted of the problem?
Cheers,
Primoz
On Tue, 2 Feb 2010 13:03:23 -0000, "Andy Pope"
wrote:
Hi,
Looks like a bug. Try referencing the latest chart object.
Dim list As Worksheet, graf As ChartObject
list.ChartObjects(1).Duplicate
Set graf = list.ChartObjects(list.ChartObjects)
Cheers
Andy
|