I couldn't tell which line had the problem.

In a different forum for a different problem (working with pivottables), someone
said that adding this line right before the offending line helped them.

Application.Wait Now + TimeSearial(0,0,1)

It's just a way to pause for a second.

I don't know if it'll help you, though.

Denis wrote:

Dave Peterson ha scritto:
The worksheet that owns the thing that should be activated has to be active.
Maybe it's as simple as making sure you're on the correct worksheet first.

Yes I'm on the correct worksheet.

application.goto Sheets(foglio_grafici).range("a1")

Why this??

Sheets(foglio_grafici).ChartObjects("Grafico 2").Activate

I do this.

with sheets(foglio_grafici)
.parent.activate
.select
.chartobjects("grafico 2").activate
end with

The error is always on SetSourceData

--
Ciao Denis

Arriva un momento nella vita in cui non rimane altro da fare che
percorrere la propria strada fino in fondo...
Quello e' il momento di inseguire i propri sogni, quello e' il momento
di prendere il largo, forti delle proprie convinzioni.

--

Dave Peterson