Chart problem : object required

[karltlbm]

Hi

I'm trying to make a chart and i use this code

ActiveChart.SetSourceData Source:=Range(nom_projet_liaison_achat!K3, ActiveCell.Offset(0, 1))

Excel tells me : error 424 object required, i don't get why because the gaph did appear ...

 

[RoryA]

You're missing some quotes:

ActiveChart.SetSourceData Source:=Range("nom_projet_liaison_achat!K3", ActiveCell.Offset(0, 1))

but that code is quite risky as it assumes your active sheet is the nom_projet_liaison_achat one.

 

[karltlbm]

Hi RoryA, thank you for your answer. But it seems that there is still a problem. nom_projet_liaison_achat is my activesheet.

This time i have a 1004 error Range of object '_Global_ failed

 

[RoryA]

If it's the active sheet, just use:

ActiveChart.SetSourceData Source:=Range("K3", ActiveCell.Offset(0, 1))

 

[karltlbm]

Thank you, it works perfectly