View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trip[_3_] Trip[_3_] is offline
external usenet poster
 
Posts: 44
Default Charts(3).SetSourceData Not Working

Hi All,

I'm a bit confused here. If I run the command "msgbox
ActiveChart.Name" I get back "Sheet1 Chart 3".

Yet, if I run the command "Charts(3).SetSourceData..." I get a
"subscript out of range" error. This is true if I try 1, 2, 3, 4, 5,
and so on. However, if I run "ActiveChart.SetSourceData..." it works,
thus I know the issue is with the "Charts(3)" portion of the line.

What am I doing wrong?

Thanks!

Trip