Hi,
I'm trying to set a range for a chart with the following:
but get an "object does not support this property or method"
What am I doing wrong (ChtRange is correct)
Thanks,Nigel
I'm trying to set a range for a chart with the following:
Code:
Sheets("Sheet4").Charts("Chart4").SetSourceData Source:=ChtRange
but get an "object does not support this property or method"
What am I doing wrong (ChtRange is correct)
Thanks,Nigel