View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Keith is offline
external usenet poster
 
Posts: 262
Default Problem error when creating a chart in VBA

Hello,
What would cause the following line...
ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$R4$C3:$R44$C3"
to produce an error number 1004?

Thanks
Keith